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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XL 2003 - Create Dialog Box to Complete Cells... 3
fill in date into adjacent cell automatically 2
Cut & Paste cells into another sheet with cell change 3
Sheet slow moving from cell to cell 1
Can I get excel to automatically fill color to all unlocked cells? 3
Cell in new sheet should always refer to defined cell in another s 8
creating form in xl. 5
VLOOKUP refuses to automatically update 1

Back
Top