Hi
what formulas do you use exactly. Maybe an IF statement would be
sufficient

--
Regards
Frank Kabel
Frankfurt, Germany

"gaba" schrieb im Newsbeitrag
...
I'm trying to create a loop to read elements from column B (the
total number
changes all the time) and based on their value, copy and paste
different
formulas stored in other cells i.e.(E:81,F:81) to the column next to
the
element:

B C D
Li Formula 1
Na 5 Formula 2
Sc Formula 1
Co Formula 3
Ni 3 Formula 2
Cu Formula 1
Mo 2 Formula 2

The elements Li, Sc, Rh, Ho use the same Formula 1, element Kr uses a
unique
formula (Formula 2), the elements with numbers in column C use
Formula 3 and
finally the rest of elements with empy spaces in C get Formula 4.

Any help will be greatly appreciated!