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! |
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) |