Date Prompt for Worksheet range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msw - 20 Dec 2005 00:50 GMT

I have a workbook and would to insert a worksheet that will capture and add
data in a separate worksheet based upon the prompt for date range that is
entered by the user.

My question is two fold:

1. How can I create a prompt for the user to enter a date range?
2. How can I create a macro that will capture the data from another
worksheet and create a new worksheet based upon the date range?

Any help would be appreciated.

Happy Holidays,

Reply to this Message

Rowan Drummond - 20 Dec 2005 02:34 GMT

In answer to question 1 this method from Ron de Bruin allows the user to
select the date from a calendar. http://www.rondebruin.nl/calendar.htm

For question 2 you would probably need to give a lot more information
before you get any good responses.

Hope this helps
Rowan

> I have a workbook and would to insert a worksheet that will capture and add
> data in a separate worksheet based upon the prompt for date range that is
[quoted text clipped - 9 lines]
>
> Happy Holidays,

Reply to this Message

Gord Dibben - 20 Dec 2005 03:05 GMT

msw

You could use a Data Filter to get the data between two dates.

You can move this filtered data to a new worksheet.

See Debra Dalgleish's site for instructions on these steps.

http://www.contextures.on.ca/xladvfilter01.html

As far as the macro goes, record what you do and see what you get for code.

You will probably have to edit any code a bit.

Also look at Ron de Bruin's site for macros for copying between sheets.

http://www.rondebruin.nl/copy1.htm

Gord Dibben Excel MVP

>I have a workbook and would to insert a worksheet that will capture and add
>data in a separate worksheet based upon the prompt for date range that is
[quoted text clipped - 9 lines]
>
>Happy Holidays,

Reply to this Message

Ron de Bruin - 20 Dec 2005 16:09 GMT

Try EasyFilter
http://www.rondebruin.nl/easyfilter.htm

It have a option to create a new workbook/worksheet with the data for you

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> msw
>
[quoted text clipped - 29 lines]
>>
>>Happy Holidays,

Reply to this Message