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

Auto Populate One Pages from spreadsheet 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Creating a Chart on form from selected data in query. 0
Auto populate value from one task to another in MS PROJECT 0
Integrating information from Word to Excel (not mail merge) 1
External cell reference between two excel worksheets both in One Drive 0
Grouping Names in Mail Merge 0
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2

Top