http://www.mrexcel.com/forum/excel-...ected-rows-multiple-sheets-summary-sheet.html
The above post is related, but to simplistic. I have a mother of a workbook...with about 30 sheets. Each sheet is formatted similarly with headers of
<tbody>
</tbody>It is based off of an AmEx bill for many years. I would like a program that would pull all the lines that start with a given Description (though many have other letters following, ie Verizon 7 is the same as Verizon 8) and pull them into a final worksheet. Ideally I would like this flexible enough that I could change the descriptor easily. The program answer attached does something similar, but for only 4 worksheets, which means in my case I would have to have 30 some segments, per worksheet, and change the descriptor many times to edit. A variable may be the way around that... If it helps all the worksheets are labelled similarly with their title being Month.18.Last 2 digits of year (ie 2.18.14 for Feb 2014).
Any thoughts would be great!
The above post is related, but to simplistic. I have a mother of a workbook...with about 30 sheets. Each sheet is formatted similarly with headers of
Date | Description | Card Member | Amount | Category | SubCategory | Trip | Receipt | Payer | Notes |
<tbody>
</tbody>
Any thoughts would be great!