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

 

 

Resources