Forum Discussion
I need to create a summary on one new sheet that pulls from multiple sheets
First, I'm new to Excel so I appreciate any help available!
I have a workbook with almost 50 sheets. Each Sheet has the same columns - one column indicates whether a product is 'saleable' (Found in column 'S'). I've been asked to create a one page summary of all the items that are Saleable.
I'm not sure sure which code to use or how to start - I think it should be pretty simple, but most examples I've seen are not quite what I'm looking for.
Thanks in advance!
6 Replies
Hi mattatkobes
What version of Excel are you using. Is it windows Office 365 version?
The Power Query feature of Excel is awesome at consolidating this type of data into one big table
If you can upload a small sample (3 tabs, 3 rows of data, all the column names) then I may be able to mock something up for you quickly
- We're using Excel 2019. I was able to work through it with my co-worker! Thank you for your reply and willingness to help!
- Great. Did you use Power Query?
mattatkobes One question you will get right off the bat from most of us here is "Why do you have 50 sheets in that workbook?" Why not assemble them all into a single sheet? If the columns are the same in each, but there's some other factor--whatever it is--that differentiates each sheet from all the others, that "factor"--again, whatever it is-- could be reflected in a single NEW column added to the columns of each.
Once the various rows from all 50 sheets are together in one large sheet, it would be simplicity itself to sift the entire long database on Column S, looking only for those rows that reflect a saleable product. And you would have your summary report.
If you want more help, it would help me (and others) if you would upload (without violating any proprietary info) samples of at least, say, three or four of your 50 sheets.
- Thank you for replying! I was able to resolve it and get the report!
