May 07 2021 07:18 AM
Hi, I feel as though this might be a simple answer but alas I'm seeking help.
I have 'transportation' sheet in my workbook that has data updated daily. I also have my 'Monitoring' tab that uses the data from 'transportation' but also includes some calculated columns. Is there a formula to use that will automatically update my 'Monitoring' tab with the new data from transportation? There is no ID to match on because it's all transportation data. The only thing I can think of is using the column headers.
Attached workbook as example
May 07 2021 11:40 AM
Tell us on the transportation tab, what are you looking for that you are looking for to prompt you to do something about it.
May 07 2021 11:44 AM
May 07 2021 02:47 PM
May 07 2021 07:56 PM
Solution
Attached is an update to your Transportation Example workbook.
the only thing you need to do to update your MonitorPage, is to go to the MonitorUpdatePage to drag the table range down to update the MonitorPage of the formulas to bring the values into your MonitorPage.
May 07 2021 07:56 PM
Solution
Attached is an update to your Transportation Example workbook.
the only thing you need to do to update your MonitorPage, is to go to the MonitorUpdatePage to drag the table range down to update the MonitorPage of the formulas to bring the values into your MonitorPage.