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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top