Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date on one worksheet, pull data from another
I'm trying to set up a fomula or macro that will allow me to enter a date on
one sheet, then find the date on another sheet within the same workbook. Then, copy certain cells within that column and paste them to certain cells within the sheet which I entered the date to begin with. What I have is a sheet with a large amount of data (the sheet I want to pull data from) and another sheet that would showcase only a portion of the data. The goal is to be able to enter a date in the one sheet and automatically pull data from the other sheet and paste it where appropriate. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date on one worksheet, pull data from another
VLOOKUP or INDEX/MATCH are the common ways of achieving this, but it
sounds as if you might have multiple rows of data with the same date, and both of these approaches only return the first occurence which matches. There other ways of doing this, however, but it would help if you could describe how your data is laid out and what you want to achieve in more detail. Pete On Nov 8, 10:08 pm, Shoney wrote: I'm trying to set up a fomula or macro that will allow me to enter a date on one sheet, then find the date on another sheet within the same workbook. Then, copy certain cells within that column and paste them to certain cells within the sheet which I entered the date to begin with. What I have is a sheet with a large amount of data (the sheet I want to pull data from) and another sheet that would showcase only a portion of the data. The goal is to be able to enter a date in the one sheet and automatically pull data from the other sheet and paste it where appropriate. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date on one worksheet, pull data from another
Okay, The data in the "main" worksheet is laid out as follows, for example:
Column A Column B 11/1/07 11/02/07 Expected Paint Sales 10000 10000 Actual Paint Sales 9000 11000 Variance % (Expected v.Actual) 10% -10% The data in the other sheet looks like this, for example Column A Column B Date: (enter date here, let's say I entered 11/1/07) Expected Paint Sales (number from 11/1) Actual Paint Sales (number from 11/1) Then if I entered 11/2/07 into the date cell, it would pull up only the desired data for that date and so on and so forth. Thank you for any help you can provide. "Pete_UK" wrote: VLOOKUP or INDEX/MATCH are the common ways of achieving this, but it sounds as if you might have multiple rows of data with the same date, and both of these approaches only return the first occurence which matches. There other ways of doing this, however, but it would help if you could describe how your data is laid out and what you want to achieve in more detail. Pete On Nov 8, 10:08 pm, Shoney wrote: I'm trying to set up a fomula or macro that will allow me to enter a date on one sheet, then find the date on another sheet within the same workbook. Then, copy certain cells within that column and paste them to certain cells within the sheet which I entered the date to begin with. What I have is a sheet with a large amount of data (the sheet I want to pull data from) and another sheet that would showcase only a portion of the data. The goal is to be able to enter a date in the one sheet and automatically pull data from the other sheet and paste it where appropriate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter date, then pull data from another sheet | Excel Discussion (Misc queries) | |||
Using one worksheet to pull data from many | Excel Discussion (Misc queries) | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
how do I enter more data to an already made pull down menu | Excel Discussion (Misc queries) | |||
How do I pull a date from a separate worksheet using the IF functi | Excel Worksheet Functions |