Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: move date by code

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,034
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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. #5
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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,"")
    Suat

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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