Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date, then pull data from another sheet
I'm trying to set up a fomula or macro that will allow me to do the
following, within a workbook: For example, the first sheet is a sheet containing multiple days worth of data. The second sheet contains fields for specific data contained in the previous sheet. For daily and weekly reporting purposes, I want to be able to enter a date (or range of dates) in the second sheet, and have the data for that day (or range of dates) autopopulate into the second sheet. Thank you for any help you can provide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date, then pull data from another sheet
Oh no, here's a third one now !!
Do you have no patience, but feel you must re-post a new thread every hour? Pete On Nov 8, 9:16 pm, Shoney wrote: I'm trying to set up a fomula or macro that will allow me to do the following, within a workbook: For example, the first sheet is a sheet containing multiple days worth of data. The second sheet contains fields for specific data contained in the previous sheet. For daily and weekly reporting purposes, I want to be able to enter a date (or range of dates) in the second sheet, and have the data for that day (or range of dates) autopopulate into the second sheet. Thank you for any help you can provide. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date, then pull data from another sheet
Hi,
I thought it didn't go through! This is my first time posting, didn't realize that someone had to reply for it to show up, the page said it would be visible in 5min. Thanks for letting me know that the post was successful. By the way, any ideas? "Pete_UK" wrote: Oh no, here's a third one now !! Do you have no patience, but feel you must re-post a new thread every hour? Pete On Nov 8, 9:16 pm, Shoney wrote: I'm trying to set up a fomula or macro that will allow me to do the following, within a workbook: For example, the first sheet is a sheet containing multiple days worth of data. The second sheet contains fields for specific data contained in the previous sheet. For daily and weekly reporting purposes, I want to be able to enter a date (or range of dates) in the second sheet, and have the data for that day (or range of dates) autopopulate into the second sheet. Thank you for any help you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
Pull data from multiple sheet | Excel Worksheet Functions | |||
how do I enter more data to an already made pull down menu | Excel Discussion (Misc queries) | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |