Tranfering data from one spreadsheet to another Automatically

M

mac

I would like to to be able to have a macro button in a spreadsheet that
when I press on it transfers the data from the current spreadsheet to
another spreadsheet save in the LAN.

In reality I will have about 600 spreadsheets per year (each one a different
project). When the project is completed, the project Manager clicks on a
button and certain cells are transferred to another spreadsheet saved in the
LAN, puts the data onto the next available blank row of another "reporting"
spreadsheet.

Can I do this?

mac
 

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

Lookups - how to obtain data from a master spreadsheet into another 5
How to transfer the data from userform to spreadsheet for specific dates 0
merge function from one spreadsheet to another 3
Importing data from another worksheet in the same spreadsheet 5
Excel Excel 2010 take data from one spreadsheet to paste to another 1
Copying a macro to another spreadsheet 1
Cannot paste a block of formulas from one sheet to another 5
Importing Data From Another Spreadsheet 7

Top