Question Locked

Excel Spreadsheet help

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to find a way to take information from a table in one spreadsheet and populate another cell in another spreadsheet. Can this be done?

2 replies

by locolobo

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.