I hate to ask someone to DO something for me, but I need this one done ASAP and its fairly complicated. Any and all help is appreciated. Ok so here is where I am at:
I have a workbook with 4 sheets. Columns A - E occupied, Row 1 Is a header, 2-50 are viable data.
What I need is a macro that will look up all four sheets. For any row that column E has a value >0, pull that corresponding row (only columns A-E) to a single summary page... alphabetically, and automatically as data in the four worksheets changes.
All it is, is an ordering workbook. I have a Janitorial tab, a forms tab, a printer toner tab, ect. Once each remote office marks in column E the quantity they are requesting, I want a simple summary page for the purchaser that populates only the items that have been requested.
Again, any help is appreciated. I am trying to learn, but I need this one done asap and it is a bit beyond the beginners guide :smile: