Hi,

Looking for some help with the attached spreadsheet please...

What I'd like to do is when someone enters a value in column A, then copy down the formulae in columns C, E and H. So for row 2, when you enter a value, I need the formuale to copied down from C1, E1 and H1 to C2, E2 and H2 respectively (even if a row is missed e.g. blank row 3 and then value entered into A4, copy down formulae). Hope that makes sense.

The worksheet is protected to protect the formulae from being removed or changed so when someone enters a value in column A, the sheet needs to be unprotected (password is 'test'), formulae copied down and then sheet re-protected with the same password.

I can do this to a point and the attached file copies column C formula but not E or H. Please help. Also, if a line is missed it doesn't copy ANY formula. Again please looking for help with this.

Note: VBA code runs when worksheet is changed.

Many thanks.

Lucas.

test.xls