M
mikewild2000
I believe i need to write a if then clause.
What i am trying to do is pretty simple in access, but in excel - i've
been at it for days.
Cells A3 to A10 always hold data. In cells D3 to D10 only one cell
holds data, which is a number "1", the other cells are null.
What i am trying to do is:
If cell D4 = 1 then fill cell D12 with the value of cell A4, likewise
if cell D7 = 1 then fill cell D12 with the value of cell A7.
How do i do this and where would i pop the code?
Just new to excel - but making good progress.
What i am trying to do is pretty simple in access, but in excel - i've
been at it for days.
Cells A3 to A10 always hold data. In cells D3 to D10 only one cell
holds data, which is a number "1", the other cells are null.
What i am trying to do is:
If cell D4 = 1 then fill cell D12 with the value of cell A4, likewise
if cell D7 = 1 then fill cell D12 with the value of cell A7.
How do i do this and where would i pop the code?
Just new to excel - but making good progress.
10,0))