updating sheets based on data in first sheet

  • Thread starter Thread starter fyrfytr265
  • Start date Start date
F

fyrfytr265

Another payroll question,
I have a workbook that contains 26 sheets, one for each bi-weekl
payroll period. I would like to set it up so when i add a new employe
the rest of the sheets also update automatically with that employee
name and information.
I have been able to acheive this to a limited degree using th
=sheet1!a1 formula, but this only updates the info in the first cel
and particularly the first column.
I would like to acheive this using the first sheet, since at th
end of the year I would like to be able to calculate ytd figure
easily.

Thank
 
If all sheets share the same structure you could just select first sheet then
right-click on the sheet tab and "select all sheets".

What you type in on first sheet will be entered on all sheets.

DO NOT forget to "ungroup sheets" when done.

BTW.... =Sheet1!A1 can be dragged and copied down or across with the A1
incrementing to A2,A3,A4 etc.

Again, do this while all sheets are selected.

Gord Dibben Excel MVP
 
Back
Top