2 replies
by 1bravesfan Accepted solution
by locolobo Accepted solution
You can link it from 1 spreadsheet to another. The simplest way to do that is to open both spreadsheets. In the spreadsheet cell you want the data to go to type in = then select the original spreadsheet, click on the cell you want the data to come from and hit Enter. If you use this method, each time you open the destination spreadsheet you will get a dialog box asking if you want to update the links.
The second is to create a Macro to copy - paste for you. I'm not the best Macro person here so I would go to
Tools - Macros - Record New Macro
Now simply copy - paste the data and hit the Stop button. Now you can run the macro when you want to do the operation. You can even tie it to a button on your spreadsheet.
Is this what you were looking for?
This discussion is closed to new replies.
Trending Software posts
Sort by Trending