Date Prompt for Worksheet range

M

msw

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

Rowan Drummond

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
 
G

Gord Dibben

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
 
Top