change all at the same time
 

I'm currently working on a sheet tracking cash over/short in a register. I've
made 52 sheets (1 per week). The sheets contains the same information. If one
of the crew quits I have to erase the person from all the sheets, and the
other way around if we hire a new person. how do I change all at the same
time?

change all at the same time
 

Select sheet 1, then hold down Alt and Shift keys and select Sheet 52....this
will highlight both sheets and ALL the sheets in between..........then just
make the change on the one sheet and all will follow........click off to
another sheet to deselect...

hth
Vaya con Dios,
Chuck, CABGx3



"brasch" wrote:

I'm currently working on a sheet tracking cash over/short in a register. I've
made 52 sheets (1 per week). The sheets contains the same information. If one
of the crew quits I have to erase the person from all the sheets, and the
other way around if we hire a new person. how do I change all at the same
time?