Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brasch
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change date based on time kdp145 Excel Discussion (Misc queries) 7 December 14th 05 02:05 AM
Can series tool change formulas over time when used to copy them compu_trainer Excel Worksheet Functions 3 May 26th 05 07:55 PM
change format for time value Qaspec Excel Discussion (Misc queries) 1 May 23rd 05 10:25 PM
HOW CAN I CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME? DEMONET48 Setting up and Configuration of Excel 0 January 14th 05 07:53 PM
Calculate change over time Gwen Excel Worksheet Functions 0 January 1st 05 05:52 PM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"