Forum Discussion
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...
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