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.
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.