SOLVED

populate values on 1 sheet using only column headers from another

%3CLINGO-SUB%20id%3D%22lingo-sub-2335446%22%20slang%3D%22en-US%22%3Epopulate%20values%20on%201%20sheet%20using%20only%20column%20headers%20from%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335446%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20feel%20as%20though%20this%20might%20be%20a%20simple%20answer%20but%20alas%20I'm%20seeking%20help.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20have%20'transportation'%20sheet%20in%20my%20workbook%20that%20has%20data%20updated%20daily.%26nbsp%3B%20I%20also%20have%20my%20'Monitoring'%20tab%20that%20uses%20the%20data%20from%20'transportation'%20but%20also%20includes%20some%20calculated%20columns.%20Is%20there%20a%20formula%20to%20use%20that%20will%20automatically%20update%20my%20'Monitoring'%20tab%20with%20the%20new%20data%20from%20transportation%3F%20There%20is%20no%20ID%20to%20match%20on%20because%20it's%20all%20transportation%20data.%20The%20only%20thing%20I%20can%20think%20of%20is%20using%20the%20column%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20workbook%20as%20example%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2335446%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2336548%22%20slang%3D%22en-US%22%3ERe%3A%20populate%20values%20on%201%20sheet%20using%20only%20column%20headers%20from%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2336548%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041172%22%20target%3D%22_blank%22%3E%40ncstle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETell%20us%20on%20the%20transportation%20tab%2C%20what%20are%20you%20looking%20for%20that%20you%20are%20looking%20for%20to%20prompt%20you%20to%20do%20something%20about%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2336551%22%20slang%3D%22en-US%22%3ERe%3A%20populate%20values%20on%201%20sheet%20using%20only%20column%20headers%20from%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2336551%22%20slang%3D%22en-US%22%3EI'm%20looking%20to%20populate%20all%20the%20data%20from%20the%20transportation%20tab%20onto%20the%20'monitoring'%20tab%20without%20having%20to%20manually%20copy%20and%20paste%20each%20time%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337064%22%20slang%3D%22en-US%22%3ERe%3A%20populate%20values%20on%201%20sheet%20using%20only%20column%20headers%20from%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337064%22%20slang%3D%22en-US%22%3EWhy%20does%20your%20Transportation%20sheet%20not%20have%20the%20%22ETA%20Hours2Deliver%22%20Field%3F%20How%20are%20you%20going%20to%20know%20if%20it%20will%20be%20on%20time%20or%20late%20based%20on%20the%20Pick-up%20appointment%20compared%20to%20the%20%22ETA%20Hours2Deliver%22%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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

 

4 Replies

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

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
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"?
best response confirmed by ncstle (Occasional Contributor)
Solution

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