Forum Discussion
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...
Hello ioannaterzi ,
you may need to revise the data architecture for this. Using Power Query (Get and Transform) in Excel 2016, you can easily combine the data from several Excel workbooks. Each person can work on a separate file and a master workbook can be set up that pulls the data from all workbooks in a folder.
Whether or not this approach works for you will depend on your data structure, though, so it would be good if you could share a few more details.
thank you for your advices, i tried macro but it crashes... im still struggling!!
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.
