Hi,
I'm looking for a VBA solution that will:
1. Look at the value in cell G7 in the sheet named "Criteria" (it will be a string of simple text, eg. Black Cat).
2. Then go to the Range E4:E1000 in the sheet named "Info" and find every instance that matches the value in G7 on the "Criteria" sheet.
3. Then return all the values in the Range F4:F1000 in the sheet named "Info" that are adjacent to the matching values found in the Range E4:E1000.
4. The values need to be returned into cell C6 downwards in sheet "Criteria" as one block, ie. no empty rows.
Hopefully this makes sense.
Any help much appreciated.
I'm looking for a VBA solution that will:
1. Look at the value in cell G7 in the sheet named "Criteria" (it will be a string of simple text, eg. Black Cat).
2. Then go to the Range E4:E1000 in the sheet named "Info" and find every instance that matches the value in G7 on the "Criteria" sheet.
3. Then return all the values in the Range F4:F1000 in the sheet named "Info" that are adjacent to the matching values found in the Range E4:E1000.
4. The values need to be returned into cell C6 downwards in sheet "Criteria" as one block, ie. no empty rows.
Hopefully this makes sense.
Any help much appreciated.