ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pulling data into today's worksheet from yesterday's worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/213486-pulling-data-into-todays-worksheet-yesterdays-worksheet.html)

Big UT Fan

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!

dlw

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!


Big UT Fan

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!


Big UT Fan

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!


Big UT Fan

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