Thanks:  0
Likes:  0

# Thread: move date by code

1. 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.

2. 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...

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

4. 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"?

5. 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,"")

6. 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.

7. 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 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•