I am looking for code please to perform the following. I have a number of spreadsheets with the same layout but varying numbers of rows. One row always begins with the same word, and another row always begins with a different word. I'd like to copy both those rows from each sheet, keeping them together, and put them into a new sheet.
Another way of expressing this:
worksheet 1
Name -------
Data
Data
Data
Total
worksheet 2
Name -------
Data
Total
The product in a new worksheet would be:
Name
Total
Name
Total.
I would be very grateful for help.
Bookmarks