Rows not moving in sync with data from Master Sheet

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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,089,961
Messages
5,411,529
Members
403,375
Latest member
vba33

This Week's Hot Topics

Top