Apply one action to all sheets in workbook

**mitelkm** · 04-11-2007, 03:43 PM

How can I apply the same action to all sheets in a workbook w/o messing up the sequence?

For example:

i have 6 sheets in a workbook:

12 ,12m; 13, 13m; 14, 14m;

12m links to 12, 13m links to 13 and so on..

I want it so that cells C6,C7,C8(13m) link to Cells b34, b35, b36 (13)
and I want to apply this action to all the sheets at the same time,
but to link to the predecsessor. 13m-13, 12m-12

(I actually have like 100 sheets on the workbook), it's way too time consuming..

Please help!

Thanks

**dominicb** · 04-11-2007, 03:51 PM

Good evening mitelkm

There are several ways to accomplish this, but the best I think for your situation would be to select the first tab. then holding down Ctrl go to and select the last tab. This will select all tabs in the workbook, and the word "Group" will appear in the title bar of your workbook. From this point on every action will be reflected in all sheet tabs. Once you want to stop the changes in every worksheet, just click any tab but the current one, or right click the tab strip and select Ungroup.

HTH

DominicB