Suz
Are the data contained in the same cells throughout each page of the
workbook?
For instance does the cell b14 on all worksheets of the workbook
contain the same information for (say) successive weeks?
If what you want to do is delete (for instance) cell B14 on all sheets,
here's what you do:
Select all sheets - you do this by right-clicking on the tab at the
bottom of the screen. If you want to select sheets 1,2,4,and 10 (for
instance) use the shift key and left click on the tabs. Select on the
sheet that is visible (the selected sheets should have their tabs
coloured white) the cell you want to delete - B14 in this example. All
contents of B14 in all the sheets you have selected should be deleted
once you hit the DEL key.
Does this fix it?
Cheers
Jon
--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile:
http://www.excelforum.com/member.php...o&userid=25803
View this thread:
http://www.excelforum.com/showthread...hreadid=398135