I have a spreadsheet that we use to keep a record of requests for
information. I have a workbook listing all requests over the last three
years. We would like to create a new workbook for each year. Without
copying and pasting, how can I have the new information that is requested
automatically be entered into the workbook for that corresponding workbook.
Any suggestions would be appreciated and thank you in advance for your time.

Look at EasyFilter
http://www.rondebruin.nl/easyfilter.htm

You can filter on Month-Year, Days, Weeknumber, Weekday, Nth Weekday, Quarter
and copy to another sheet or workbook


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



"urguy" <(E-Mail Removed)> wrote in message news:E5BAD0A1-4A9D-47B3-81E9-(E-Mail Removed)...
>I have a spreadsheet that we use to keep a record of requests for
> information. I have a workbook listing all requests over the last three
> years. We would like to create a new workbook for each year. Without
> copying and pasting, how can I have the new information that is requested
> automatically be entered into the workbook for that corresponding workbook.
> Any suggestions would be appreciated and thank you in advance for your time.