Hey all,

I need a script that will do some calculations for me...

For eg:

I've got cells B5 to H5 with the total being in I5

my calculations would be =B5/$I$5*100 for B5 and so on..and I've go
nearly 5000 rows with similar calculations. Is there a script that can
use this calculations and run once???Please help...thanks heaps

If I understand you correctly, you should use

=B5/I5*100

So, without the dollar signs.
You can copy thus formula down and the row numbers will adjust automatically

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


<adachan3505@gmail.com> wrote in message news:a598b594-e857-4df6-a9ce-2279b721e339@s19g2000prg.googlegroups.com...
| Hey all,
|
| I need a script that will do some calculations for me...
|
| For eg:
|
| I've got cells B5 to H5 with the total being in I5
|
| my calculations would be =B5/$I$5*100 for B5 and so on..and I've go
| nearly 5000 rows with similar calculations. Is there a script that can
| use this calculations and run once???Please help...thanks heaps