Very easy question for Excel people

[mattpearcey]

I am formulating an Excel spreadsheet to help data gathering and importing for my access database. I have many worksheets that all relate to one record, say a name, is there a way that i can make the cells on the first worksheet throw that name into the related cells on the other worksheets? So i dont have to enter the name everytime i change worksheet. So, for example, cell A3 on the Introduction worksheet i enter the name, then the name will be in all of the A3 cells on all of the worksheets, and so on down the list of names.

Any ideas?
Thank you for your help already.

Matt Pearcey

 

[donna6197]

If you select all the worksheet tabs (ie click on the tab for sheet 1, hold down the shift key and click on tab for the last sheet) and then enter the name in A3, then the name should appear in A3 on all sheets selected.

 

[mattpearcey]

Donna - You are a star!!

Thank you! Thank you for your help already.

Matt Pearcey

 

[JVFriederick]

1) Use a formula reference on sheet #2, enter as =+$A$3
2) Right click on sheet #1, select Select All Sheets. Now whatever you type will also be entered on every other sheet. To deselect the grouping of sheets, click on one of the other sheets.