Hello, looking for assistance on dynamically copying/pasting a "key" from a master tab, to subsequent tabs, two rows after the last row of data. Each report run is different so the location of the key on the "master" tab will not be in the same location each time. I always need help with the 'finding last row' type coding, so hoping for help here, thanks in advance.
On the "master" tab, the key will always be in columns A:C and begin with "BOLD =" which I believe the code could search for, then 1 row down, and 2 rows over. From there, those cells need to be copied/pasted to the other tabs the same, after the last row of data, 2 rows down.
All subsequent tabs begin in row 9 and if there is no data in row 10, then the tab will be blank (contain no data) and there is no need for a key to be pasted.
Attached is a sample showing what I am trying to accomplish. Thanks so much for any help on this.
Sheryl
Bookmarks