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 ...
My monthly sheets have the exact same information and structure each time. So if I have them in a separate folder and use file>from folder connector, can I continue to add months to it in the future and it still combine the data correctly?
Yes, you may add / remove files when needed. You may start from two-three sample files to see how it works. On first step you'll see list of all files, click on Combine Files button on Content column and follow the wizard, make other transformations if necessary.