Forum Discussion
ioannaterzi
Feb 02, 2019Copper Contributor
Merge multiple excel files into one (the formatting of the file also)
Dear all, Im using excel 2016. me and my colleuages are working on an identical file(we make copy of the file for each one of us every morning) but we are putting data in different row and colums...
ioannaterzi
Feb 08, 2019Copper Contributor
thank you for your advices, i tried macro but it crashes... im still struggling!!
Eva Vogel
Feb 09, 2019Iron Contributor
Hello ioannaterzi ! I think IngeborgHawighorst is right to do your issue with power query. Here is a youtube video for your posted question:
https://www.youtube.com/watch?v=NHNnnuOF8kU
Greets ,Eva.