How do I automatically copy data from one workbook to another?
 

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.

How do I automatically copy data from one workbook to another?
 

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" wrote in message ...
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.