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' (Fou...
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?
This is all new to me - but my co-worker had a separate sheet with formulas that gets things done! lol...She's a coder so that's helpful. I was trying to use initiative and got in over my head but I'm good now! Thanks so much for your willingness to help! Wyn Hopkins