Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from another worksheet | Excel Discussion (Misc queries) | |||
Pulling data through to another worksheet | New Users to Excel | |||
Pulling data from another worksheet thru a formula | Excel Discussion (Misc queries) | |||
Pulling data from one worksheet to another | Excel Worksheet Functions | |||
Pulling Data from Another Worksheet | Excel Discussion (Misc queries) |