Hi all,
I've been spooking around the forum for a year or so now and have recently started delving into the depths of VBA. Anyway.
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" (B2) and copy everything 1 cell below Count down to five cells to the right of the text "Grand Total" (cell F20). Not only that but I need to do the same for multiple instances of the same text in multiple tables on a worksheet, in multiple sheets in a workbook.
I have several tables that change from month to month and the only consistent values are the "Count" and "Grand Total" in each table.
Any help would be appreciated.
Bookmarks