MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sharing Data / Values Multiple Sheets? HUH?


Posted by Dave on August 06, 2001 1:23 PM

Any ideas how to share values in a cell across other spreadsheets? I want to input a value...name date whatever and have the data populate in another spreadsheet in teh same xls file. Actually Two other places. Same data to be populated.

Any ideas?


Posted by Cory on August 06, 2001 2:43 PM

Say you want cell A1's data to populate itself in sheet2's A1, sheet3's A1, etc...
Go to the second sheet and click in the cell where you want your result(A1). type = then switch back to the first page. Click on cell A1. Press enter. The value of the first sheet's A1 should now show in the second sheet's A1.

That what you're looking for?

Cory