ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Enter date, then pull data from another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/165336-enter-date-then-pull-data-another-sheet.html)

Shoney

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.

Pete_UK

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.




Shoney

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.






All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com