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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,090,489
Messages
5,414,838
Members
403,548
Latest member
frostinheart

This Week's Hot Topics

Top