How to insert a column with formula into multiple sheets on a workbook?

[h3rm4w4n]

Hi,
Need help..

I have an excel file with almost a hundred of sheets
all sheet has same structure
the for example ut has column left to right:


AA,BB,CC,DD,EE,FF,GG,HH,II,JJ,KK

(AA=column A,BB=column B, CC=column C....)

I need to insert a column between II and JJ
I call the inserting column is IIb
so it will be:
AA,BB,CC,DD,EE,FF,GG,HH,II,IIb,JJ,KK

(IIb became column J, and J at column K .. )


and the IIb has formula = JJ/II

it should be applied to all sheets

Need help. I use Excel 2007 or excel 2003..

Thanks

Regards,
Hermawan

 

[JazzSP8]

Hi Hermawan - Welcome to the forum

If the structure is exactly the same across all sheets then you can right click on the sheet name at the bottom and "Select All Sheets".

Then you can make the changes to one worksheet and it should reflect on them all.

HTH

 

[h3rm4w4n]

Thanks, It works...