move date by code

cblincoln43 · Apr 20th, 2002, 03:56 PM

I have cells H7:H12,set for code entrys from say A thru Z. More specificly "M","S","A","E","H" & "R".
What i need is if CELL H7, has an "M" entered then the date in CELL D7, WILL TRANSFER INTO CELL D17.

Juan Pablo González · Apr 20th, 2002, 03:58 PM

Quote:

On 2002-04-20 14:56, cblincoln43 wrote:
I have cells H7:H12,set for code entrys from say A thru Z. More specificly "M","S","A","E","H" & "R".
What i need is if CELL H7, has an "M" entered then the date in CELL D7, WILL TRANSFER INTO CELL D17.

If [H7] = "M" Then
[D17] = [D7]
End If

Is this what you're after ? I'm really not sure...

Mark W. · Apr 20th, 2002, 03:59 PM

...and, if H7 <> "M"?

Aladin Akyurek · Apr 20th, 2002, 03:59 PM

Quote:

On 2002-04-20 14:56, cblincoln43 wrote:
I have cells H7:H12,set for code entrys from say A thru Z. More specificly "M","S","A","E","H" & "R".
What i need is if CELL H7, has an "M" entered then the date in CELL D7, WILL TRANSFER INTO CELL D17.

In D17 enter:

=IF(H7="M",D7,"")

Is this what you're looking for? If so, what happens with the rest of your "codes"?

smozgur · Apr 20th, 2002, 04:02 PM

If D17 would be blank when H7 is not "M" then you can put this formula into D17 directly to show D17 blank when H7 isnot "M" and =C7 when it is "M".

=IF(H7="M",C7,"")

cblincoln43 · Apr 20th, 2002, 04:24 PM

H7:h12 will be blank untill entry. then each letter entewred will take that rows date and transfer it to the letters respective cell an in "m" into h7 will transfer d7,"the date" into it's cell or d17. each letter having its own cell to go to.

cblincoln43 · Apr 20th, 2002, 06:06 PM

Hope to clear up my needs.
I would like to enter into cells H7 thru H12 a letter from A to Z, these cells have no formula in them.
When i enter say "M" then the date for that row will transfer to the cell designated by the letter "M".
If h7 thru h12="m" then d7 (the date) will transfer to d17.. If h7 thru h12 = "s", then d12 (the date) will transfer to d20. and so on... Keep getting #value with these formulas.
I keep getting #value if i try, =if(h7:h12="m",d7:d12,"""") ???????help.

[ This Message was edited by: cblincoln43 on 2002-04-20 17:13 ]

[ This Message was edited by: cblincoln43 on 2002-04-21 06:19 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 03:56 PM	#1
cblincoln43 Board Regular Join Date: Mar 2002 Posts: 204	I have cells H7:H12,set for code entrys from say A thru Z. More specificly "M","S","A","E","H" & "R". What i need is if CELL H7, has an "M" entered then the date in CELL D7, WILL TRANSFER INTO CELL D17.

Apr 20th, 2002, 03:59 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	...and, if H7 <> "M"?

Apr 20th, 2002, 04:02 PM	#5
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	If D17 would be blank when H7 is not "M" then you can put this formula into D17 directly to show D17 blank when H7 isnot "M" and =C7 when it is "M". =IF(H7="M",C7,"")

Apr 20th, 2002, 04:24 PM	#6
cblincoln43 Board Regular Join Date: Mar 2002 Posts: 204	H7:h12 will be blank untill entry. then each letter entewred will take that rows date and transfer it to the letters respective cell an in "m" into h7 will transfer d7,"the date" into it's cell or d17. each letter having its own cell to go to.

Apr 20th, 2002, 06:06 PM	#7
cblincoln43 Board Regular Join Date: Mar 2002 Posts: 204	Hope to clear up my needs. I would like to enter into cells H7 thru H12 a letter from A to Z, these cells have no formula in them. When i enter say "M" then the date for that row will transfer to the cell designated by the letter "M". If h7 thru h12="m" then d7 (the date) will transfer to d17.. If h7 thru h12 = "s", then d12 (the date) will transfer to d20. and so on... Keep getting #value with these formulas. I keep getting #value if i try, =if(h7:h12="m",d7:d12,"""") ???????help. [ This Message was edited by: cblincoln43 on 2002-04-20 17:13 ] [ This Message was edited by: cblincoln43 on 2002-04-21 06:19 ]