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,

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

msw wrote:
> 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,
>
>

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


On Mon, 19 Dec 2005 19:50:28 -0500, "msw" <(E-Mail Removed)> wrote:

>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,
>

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

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


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


"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
> 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
>
>
> On Mon, 19 Dec 2005 19:50:28 -0500, "msw" <(E-Mail Removed)> wrote:
>
>>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,
>>