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!

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!

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!

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!

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!