Forum Discussion
How Can I Link Multiple Workbooks
Dear All Experts, I am new to Excel, My boss asked to resolve one query, I have 3 workbooks each workbooks contain 6 worksheets, Let's assume, I have Company_1.xlsx then Company_2.xlsx & Company_...
It looks like job for Power Query - you may query all 3 workbooks, make transformations, load to master and make any cosmetic on the top.
With links it won't be reliable, any change in data layout could break them. But it all depends on how concrete data is structured.
I really appreciate sir, thank you so much for reply, But would you please tell me, how can I do this in Excel, and also I want my data should be syncing with other workbooks
Regards,
Arif
Regards,
Arif
That's too abstract, sorry. Everything in Excel could be done by few different ways, which one to use depends on concrete data.
If to start with Power Query you may check this template form File->New