Forum Discussion

ncstle's avatar
ncstle
Copper Contributor
May 07, 2021
Solved

populate values on 1 sheet using only column headers from another

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...
excel
Formulas and Functions
  • Yea_So's avatar
    Yea_So
    May 08, 2021

    ncstle 

     

    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.

     

     

Yea_So's avatar
Yea_So
Bronze Contributor
May 07, 2021

ncstle 

 

Tell us on the transportation tab, what are you looking for that you are looking for to prompt you to do something about it.

ncstle's avatar
ncstle
Copper Contributor
May 07, 2021
I'm looking to populate all the data from the transportation tab onto the 'monitoring' tab without having to manually copy and paste each time
  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    May 07, 2021
    Why does your Transportation sheet not have the "ETA Hours2Deliver" Field? How are you going to know if it will be on time or late based on the Pick-up appointment compared to the "ETA Hours2Deliver"?

Resources