I have two workbooks:
WB1= SourceWB
WB2 = DestinationWB
I am trying to copy data out of the SourceWB into the DestinationWB, as long as it meets certain criteria.
The attached file serves only as a limited example, as the original SourceWB is over 3000 rows long (and dynamically changes), and contains over 200 columns of data.
Basically, I would like to
1) copy all rows/cells of data (excluding the header row) from Sheet1 of the SourceWB down to the point where I first encounter the word "Buckets", and then
2) paste those values into Sheet1 of the DestinationWB.
So in my attached workbook, this would involve copying the range B2:G15 of Sheet1...as B16 is where i first encounter the word "Buckets".
(Alternatively, D16 is the first cell in Col D that is blank, so that also serves as a check for where the word "Buckets" first appears.)
Again, these ranges are dynamic and much larger on the original workbooks.
Any help would be extremely appreciated.
Thanks in advance!
Bookmarks