Change the same unit in different worksheets

[Guest]

I have a workbook with a few worksheets. In B2 of all the worksheets, it is a date like "March 31". Now I want to change it to "April 30" for B2 in all worksheets. Any easy method?
Thanks in advance.
Plumstone

 

[Paul B]

Plumstone, group the sheets and make the change, select the first sheet and
hold the shift key, select the last sheet, select B2 and make your change to
the date, the date will be put in all the selected sheets, right click on
one of the sheet tabs and ungroup
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

I have a workbook with a few worksheets. In B2 of all the worksheets, it

is a date like "March 31". Now I want to change it to "April 30" for B2 in
all worksheets. Any easy method?

 

[Guest]

Thanks.

Plumstone, group the sheets and make the change, select the first sheet and
hold the shift key, select the last sheet, select B2 and make your change to
the date, the date will be put in all the selected sheets, right click on
one of the sheet tabs and ungroup
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **


is a date like "March 31". Now I want to change it to "April 30" for B2 in
all worksheets. Any easy method?

 

[Guest]

Thanks.
Plumstone

If they are all in the same book, click on the first sheet name. Then, hold down shift and click on the last sheet name. All the sheets from the first click to the last should turn white. You should also see the word [Group] after the filename on the title area of your Window. Then, type the new date in the cell. Right-click on any sheet name included in the group (the white tabs), then, choose Ungroup Sheets from the top of the list.
If all the sheets are not right next to each other, use Ctrl instead of Shift to select them.

tj

I have a workbook with a few worksheets. In B2 of all the worksheets, it is a date like "March 31". Now I want to change it to "April 30" for B2 in all worksheets. Any easy method?
Thanks in advance.
Plumstone