Copy Formula from set cells, paste in blank rows below as value

[cappie]

Hi all,

This is my very first post. 'Hi' in advance, and thanks for the help.

I've searched high and low and am stumped, here we go. I use VB, but cannot code as such. Rather copy, paste, and tweak:

1. I have formulas in cells D2:F2 and I2:K2.
2. Data is added to column A via a userform.
3. I want to apply the above formulas (1) in all rows with new data in corresponding row A, and then paste.special as value only
4. So the data below row 2 will always just be values, but as new data is added in column A, I want to paste the formulas to the length of column A.
5. All rows below row 2 (D3:F and (3:K) must not be updated/changed when the formula runs. If the cell is not empty, don't update

Thanks again in advance from a sunny South Africa

[cappie]

Still stuck...anyone got any ideas?