June 18, 2019
I have a worksheet with original data that i have created multiple power queries from for each team member to action and add their comments.
I'm then trying to do a power query back from these tables into a master spreadsheet. I can get one workbook to come through however the others appear as an error. saying An error occurred in the 'Transform File from New Test files' query. Expression.Error: The key didn't match any rows in the table. Details: Key = Record
As the headings are already created from a query and I have checked they are identical why won't this work?
Is there a better way where we have a data base, then assign to multiple of people to action and load their updates back to a master file?
Any help will be greatly appreciated as currently it is a very manual process.