Need help consolidating data across multiple sheets

[BrianSells]

I have a workbook with 16 separate worksheets with multiple columns. I'd like to create a 17th sheet that would consolidate all the data from the other sheets ONLY if there is a value entered in for quantity ordered. I would like to do it without VBA if possible, but if I need to it's not a problem. The tricky part(to me anyway), is that I only need certain cells from each row to transfer over to the new sheet. Is this possible. For example, I have columns A thru G with headers, (Quantity Ordered, Item Number, Description, Price, Category, etc.) On the final sheet, I just need 3 of the cells from each row, (qty, item and description) but would like to have them automatically placed under the correct header on the final sheet. BTW, the final sheet headers are arranged differently and some are named differently. Any ideas? Thanks in advance for any help!

[JBeaucaire]

It would require VBA to do in any simple manner. I can set that up for you so that each time you bring up sheet 17, it goes out and collects all the data from all other sheets and refreshes it's data, all the time.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

[BrianSells]

Warehouse Store Order List 4-30-12.xlsx
Many thanks for the help. I need the final sheet titled"Pick List" to get the info from the rest of the workbook.

[JBeaucaire]

Take a look.... right-click on the Pick List tab and VIEW CODE to see the macro.

[BrianSells]

You sir, are the man! That does exactly what I need. Can't thank you enough, I have wrestled with this all day trying to figure it out. Now I'm going to try getting some code in to clear all the ordered columns on the worksheets. this may require a button on the Pick List, but i can handle that. I'm not a total newb to VBA but very far from experienced. Learning as I go and you have been a great help!

[JBeaucaire]

Please Login or Register  to view this content.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.

[BrianSells]

Thanks for everything.....You may hear from me later, I'm trying to add some user controls for this workbook.