I have an expense spreadsheet containing two sheets (car mileage & other
expenses). Ideally, when a user opens the template, I'd like them to see a
dialog box asking for Name (say, cell C4), Payroll Number (cell G4) and Date
(cell N4). When they complete the dialog box and click on OK, the cells are
populated and the corresponding cells on the second sheet are also completed
(which I know are just formulae referring to the cells on the first sheet).
Any help gratefully accepted.
TIA
Amanda
Bookmarks