Quote:
Originally Posted by M.D. Holloway
ok, may be this will help. I want cell B5 in spreadsheet 1 to fill in C8 in spread sheet 2.
|
I'm no guru, but what you described can be done as follows. My version is Excel Professional 2010. Open your Spreadsheet1. Open your Spreadsheet2. To make things easily visible, click the 'View' button, then 'Arrange All', then 'Vertical' so that you can see your two open spreadsheets side-by-side. Now, in Spreadsheet2, go to cell C8. Type the equals sign "=", then click on cell B5 in Spreadsheet1. Hit enter, and the contents of B5 in Spreadsheet1 will populate into cell C8 of Spreadsheet2.
The formula in C8 of Spreadsheet2 will look like this: =+[Spreadsheet2]Sheet1!$B$5
Is this what you are trying to do?