Tom Platania
New Member
- Joined
- Apr 28, 2015
- Messages
- 5
Hello,
I have had an excel person working on combining sheets without our company, so one master sheet would be used to automatically transfer data to 6-7 other sheets.
The issue, as we add data, the linked sheets update, the row going across does not stay consistent all the way across. meaning Jones project, in A1, will show the completed date for Smith project in j1.
I can provide more information if needed. The excel person we hired, is using Power Query to combine the information for sheet to sheet.
Tom
I have had an excel person working on combining sheets without our company, so one master sheet would be used to automatically transfer data to 6-7 other sheets.
The issue, as we add data, the linked sheets update, the row going across does not stay consistent all the way across. meaning Jones project, in A1, will show the completed date for Smith project in j1.
I can provide more information if needed. The excel person we hired, is using Power Query to combine the information for sheet to sheet.
Tom
