I require help with a reasonably complicated VBA macro loop for a dataset I've been provided. The dataset exists as one long column one thousands of different entries.
I've tried recording macros but I am at a loss at the best way to approach it. Any help would be greatly appreciated. In its simplest terms, I need to locate a term (ie. "THIS IS A TEST"), copy that cell into new worksheet, go 72 cells up and copy whatever is in that cell into the new worksheet as well.
Logic for the VBA macro Loop...
- Scan through all worksheets for the words "THIS IS A TEST"
- Copy that cell into a new worksheet (eg. A1)
- Go 72 cells up
- Copy that cell into the new worksheet (eg. B1)
It needs to loop through the above logic across all open worksheets, dumping the results into a new worksheet.
Once again, thanks for any help I recieve.