PDA

View Full Version : Selecting range relative to found values - Multiple Instances



Maverick21
12-03-2013, 02:38 PM
Hi all,

I'm trying to select a relative range based on a value found in a worksheet. In the attached, my goal would be to find the text "Count" and copy everything 1 cell below Count down to 19 cells to the right of the text "Grand Total" . Not only that but I need to do the same for multiple instances of the same text in multiple tables on a worksheet. Each range would be copied, then pasted to another template.

Then I need to proceed to the next sheet and do the same.



What I'm basically looking for is

Select Range: Find (in column B instance 1 of "Count")+1 row down: Find(Instance 1 of "Grand Total")+ 1 row right:19 rows right
Copy


Repeat for instance 2 etc....
10919
Any help would be appreciated.

p45cal
12-04-2013, 12:15 PM
See button on attached sheet and comments in the code of macro called blah2.

It's probably overly complex as I was trying to ensure that instances of "Count" and "Grand Total" were properly paired, in case there were any missing instances of either causing more than one table to be copied.

Maverick21
12-07-2013, 09:07 AM
See button on attached sheet and comments in the code of macro called blah2.

It's probably overly complex as I was trying to ensure that instances of "Count" and "Grand Total" were properly paired, in case there were any missing instances of either causing more than one table to be copied.

Thanks p45cal for the help. Digging in now before the big OU OSU game.