Aug 20 2020 04:29 PM
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.
Aug 21 2020 01:38 AM
@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'