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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
hiden cells copied automatically to another workbook, can I stop . 2
Pulling data from another workbook 2
copy between workbooks 3
How do I take data from one workbook and enter it into another? 4
trouble copying a cell from one workbook to a new one 2
copy data from one excel workbook to another workbook using macro 4
Copy formulas from one workbook to another 1

Back
Top