Pulling data into today's worksheet from yesterday's worksheet
I create daily worksheets. Each row has a unique identifier (UID). These
UIDs even drop off thru time and new ones are added. The data that I want to pull forward is a priority (PRI - a numeric value) and possibly a target date (if it exists). I doubt I've made this clear so I'll try to describe it again. An example, each worksheet will have col A (UID), col B (PRI) and col C (DATE). For every UID in today's worksheet that matches a UID in yesterday's worksheet I want to populate today's worksheet with the corresponding PRI and DATE from yesterday's worksheet. The worksheets are named MMDDYYYY. I'd like to have either a macro that I could run or function values in cols B & C that pulls this data. Can anyone help? Thanks! |
Pulling data into today's worksheet from yesterday's worksheet
sounds like a job for the vlookup function
"Big UT Fan" wrote: I create daily worksheets. Each row has a unique identifier (UID). These UIDs even drop off thru time and new ones are added. The data that I want to pull forward is a priority (PRI - a numeric value) and possibly a target date (if it exists). I doubt I've made this clear so I'll try to describe it again. An example, each worksheet will have col A (UID), col B (PRI) and col C (DATE). For every UID in today's worksheet that matches a UID in yesterday's worksheet I want to populate today's worksheet with the corresponding PRI and DATE from yesterday's worksheet. The worksheets are named MMDDYYYY. I'd like to have either a macro that I could run or function values in cols B & C that pulls this data. Can anyone help? Thanks! |
Pulling data into today's worksheet from yesterday's worksheet
Thanks. I'll take a look at VLOOKUP. I'd also like to be able to use some
type of date function to specify "yesterday's" worksheet in the function. Make sense? "dlw" wrote: sounds like a job for the vlookup function "Big UT Fan" wrote: I create daily worksheets. Each row has a unique identifier (UID). These UIDs even drop off thru time and new ones are added. The data that I want to pull forward is a priority (PRI - a numeric value) and possibly a target date (if it exists). I doubt I've made this clear so I'll try to describe it again. An example, each worksheet will have col A (UID), col B (PRI) and col C (DATE). For every UID in today's worksheet that matches a UID in yesterday's worksheet I want to populate today's worksheet with the corresponding PRI and DATE from yesterday's worksheet. The worksheets are named MMDDYYYY. I'd like to have either a macro that I could run or function values in cols B & C that pulls this data. Can anyone help? Thanks! |
Pulling data into today's worksheet from yesterday's worksheet
I greatly simplified my example. Lots of other cols in the worksheets. I
thought I might be able to separate the table_array from the col_index_num but that doesn't look possible. UID is in col 3 for example, with PRI in col 1 and DATE in col 7. From reading, the help page I don't see how this will work for me. "dlw" wrote: sounds like a job for the vlookup function "Big UT Fan" wrote: I create daily worksheets. Each row has a unique identifier (UID). These UIDs even drop off thru time and new ones are added. The data that I want to pull forward is a priority (PRI - a numeric value) and possibly a target date (if it exists). I doubt I've made this clear so I'll try to describe it again. An example, each worksheet will have col A (UID), col B (PRI) and col C (DATE). For every UID in today's worksheet that matches a UID in yesterday's worksheet I want to populate today's worksheet with the corresponding PRI and DATE from yesterday's worksheet. The worksheets are named MMDDYYYY. I'd like to have either a macro that I could run or function values in cols B & C that pulls this data. Can anyone help? Thanks! |
Pulling data into today's worksheet from yesterday's worksheet
Additionally, only the priority column is in any sorted order.
"dlw" wrote: sounds like a job for the vlookup function "Big UT Fan" wrote: I create daily worksheets. Each row has a unique identifier (UID). These UIDs even drop off thru time and new ones are added. The data that I want to pull forward is a priority (PRI - a numeric value) and possibly a target date (if it exists). I doubt I've made this clear so I'll try to describe it again. An example, each worksheet will have col A (UID), col B (PRI) and col C (DATE). For every UID in today's worksheet that matches a UID in yesterday's worksheet I want to populate today's worksheet with the corresponding PRI and DATE from yesterday's worksheet. The worksheets are named MMDDYYYY. I'd like to have either a macro that I could run or function values in cols B & C that pulls this data. Can anyone help? Thanks! |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com