Feb 02 2019 02:58 AM
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 of the file. After we are done , we want to conbine all this information together into a master file and keep the formating of our files. Does anybody knows how to do it? its a daily job that i have to do.
Thank you in advance :)
Feb 02 2019 04:59 AM - edited Feb 02 2019 05:12 AM
Feb 03 2019 11:57 AM - edited Feb 03 2019 12:02 PM
@Eva Vogel The OP is talking about "colleagues" working on the files, so advising them to create personal Microsoft accounts is probably not a good idea. It will be the nightmare of any IT department to see employees farm out company files on personal cloud shares that IT can't control. I'd be very hesitant to give out such advice.
Feb 03 2019 12:02 PM
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.
Feb 08 2019 02:17 PM
thank you for your advices, i tried macro but it crashes... im still struggling!!
Feb 09 2019 12:46 AM
Hello @ioannaterzi ! I think @Ingeborg Hawighorst 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.