Forum Discussion
Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
Hi, I have this spreadsheet that I am working on and it contains multiple worksheets of data. I would like to combine all that data into one and create PivotTables out of them. I would also like to ...
I'm concerned that @Rujinh may not know where to go to implement what you've suggested.
Concerned because I don't know either. Where would he (or I) find that File->From Folder connector you refer to? I've looked for it--from your description here it sounds like it could be VERY helpful--but I don't find it under the File menu, the Insert or Data tool bars.....Is it possible that since I'm on a Mac, that what you're referring to is only in the Windows version of Excel? (I have the most current Mac, with full access to the Dynamic Array functions)..
Thanks. I always appreciate your far more advanced expertise.
I'm sorry, you are right. That's Power Query and that's Excel for Windows desktop.