Change cell values based on other cells.

Hi,

Try this...

There are some valid datas in the cells A2 (Eg. 100), B2(Eg. 200), C2 and D2.
Data validation is used in cell K2 to limit it to a set of values.

Can we implement this formula?

IF(K2="Approved")
{
A2=A3; B2=B3; C2=C3; D2=D3; K2=K3;
}
ELSE
{
no change to any values.
}

Thanks in advance...

Hello,

are the values in A2, B2, C2 and D2 entered manually?

If so, you can not change them with a formula. You will need VBA to do that.

Are you open to a VBA solution?

It would help immensely if you could post a sample Excel file with some data that reflects your needs. Click "Go Advanced" below and then the paper clip icon to attach a file.

cheers,