Merging 4 or more workbooks -

Copper Contributor

Hi there, sorry I'm a fairly basic excel user! I am trying to work out if I can merge data from separate work books to save me having to input the information time and time again.  I hope that makes sense!

Cheers.

1 Reply

@Leni13 there are many guides online.

as an example this

 

https://www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/

 

alternatively you can google

'excel power query merge workbooks'