Here is what I'd like to do.. I have a report that is full of garble we'll call it report.xls . It's like 30,000 rows long..
I'd like a vba solution in a new workbook w/ 3 rows
Dept - Salary - Benefits
In the dept column I'd like to look in report.xls and everytime it finds the word "Department Totals" to move right 3 columns and up 6 rows and pull that number. First placing the result in A2, then moving down to A3 and placing the next result, the A4, etc.. etc.. There are a ton of different department #'s, but they're always in the same position... I just want it to search for all instances until the end of the worksheet. Once that's figured out I'm sure I can apply the same vba to the other 2 columns (salary and benefits). Thanks for any help offered!
If anyone would like a sample of the excel file, please let me know. Thanks!