Forum Discussion

Lincoln5800's avatar
Lincoln5800
Copper Contributor
Dec 17, 2019

Excel Data Tracking from Sheet to sheet

I have an Excel workbook that has two sheets. The one sheet changes as we enter new information in the same cells each time we receive a call. The other sheet was made to track the information logged in the 1st sheet. However I want to keep the previous information put in sheet one on the tracking sheet when we change the 1st sheet. 

 

I have the formula as an IF function and it works based on the tracking number. 

 

Example:

 

Call One

Tracking # A1   Sheet 1 shows Caller Name as John and Sheet 2 then shows Callers name as John 

 

Call two 

Tracking # (Changed to) A2 so on sheet 2 the new caller would be put in row 2. 

 

At this time when we enter the second caller because the cells are not changing it deletes the saved information from row 1 on sheet 2. 

 

1 Reply

  • Lincoln5800's avatar
    Lincoln5800
    Copper Contributor

    I reversed the sheets and made it so I input data in the tracking log and the other sheet copied the data. By using the following formula. =VLOOKUP('Work Order '!D1,'Tracker '!A4:I103,5,FALSE)Lincoln5800 

Resources