XL 2003 Automatically filling in cells on two sheets on opening...

B

Birmangirl

I have an expenses spreadsheet with two tabs (car-related and other). Each
sheet requires the user to fill in their name, payroll number, and date.
Everything else is calculated for the user.
Would it be possible to have a dialog box open when the template is opened
(similar to what Word can do), whereby a user can complete these fields only
once and the dats is entered on both sheets.
TIA
Amanda
 
M

Manoj

Link the second sheet to the first sheet. So that once you enter the data on
the first sheet, the same data is automatically populated in sheet 2 as well.
Use a simple "=" and the cell reference of the first sheet to do this.

See if this works

manoj
 
Top