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!