Forum Discussion
Copying data from different sheets
Hello All, I have 3 different excel workbooks on OneDrive in different folders. Ex sales, accounts and purchase folders has each excel sheet. In each workbook there are different columns with...
That could be done by Power Query if you consider such option
Thanks for the info sergei.
Can you help me in power query. I am finding difficulty in choosing the columns and getting all the columns in one common sheet.
Thanks
Can you help me in power query. I am finding difficulty in choosing the columns and getting all the columns in one common sheet.
Thanks
That's bit abstract, better to have small sample file.
In general you query table/range from each sheet, keep queries as connections. How to combine depends on your data layout and what do you need. If each all tables have the same structure you may append them each to other and generate one table where data from sources will be one after another.
If you have columns with ID:s or its equivalent in each source you may merge the queries selecting from each source only columns you need. That will be another kind of common sheet.