Results 1 to 10 of 380

Thread: Appendix Thread. ( Codes for other Threads, etc.) Event Coding Drpdown Data validation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,479
    Rep Power
    10

    Appendix Thread. ( Codes for other Threads, HTML Tables, etc.) Event Coding

    So my solution, which I will give in the next post will solve this problem, which is your problem shortened.

    _____ Workbook: Autofill.xlsx ( Using Excel 2007 32 bit )
    Row\Col
    B
    C
    D
    E
    F
    G
    2
    S. No.
    Alpha Code
    Sex
    Category
    Area
    3
    1
    4
    2
    5
    3
    Worksheet: Sheet1
    Case1
    If I paste or enter A in cell C3, then, automatically put the value…
    BOY in cell D3, GEN in cell E3 and URBAN in cell F3
    Similarly,
    If I paste or enter B in cell C3, then, automatically put the value…
    BOY in cell D3, OBC in cell E3 and URBAN in cell F3
    Similarly,
    As shown in REFERENCE CHART)
    the corresponding value should filled in the corresponding cells automatically
    Now,
    Similarly,
    same condition is applied to cell C4, C5, C6 and so on
    that is,
    If I paste or enter A in cell C4, then, automatically put the value…
    BOY in cell D4, GEN in cell E4 and URBAN in cell F4

    _____ Workbook: Autofill.xlsx ( Using Excel 2007 32 bit )
    Row\Col
    R
    S
    T
    U
    V
    W
    1
    REFERENCE CHART
    2
    S. No.
    Alpha Code
    Sex
    Category
    Area
    3
    1
    A
    BOY
    GEN
    URBAN
    4
    2
    B
    BOY
    OBC
    URBAN
    5
    3
    C
    BOY
    SC
    URBAN
    6
    4
    D
    BOY
    ST
    URBAN
    7
    5
    E
    GIRL
    GEN
    URBAN
    Worksheet: Sheet1

    Case2
    If I paste or enter BOY in cell D3, GEN in cell E3 and URBAN in cell F3
    then, automatically put the value A in cell C3
    Similarly,
    If I paste or enter BOY in cell D3, OBC in cell E3 and URBAN in cell F3
    then, automatically put the value B in cell C3
    Last edited by DocAElstein; 07-04-2020 at 01:24 PM.

Similar Threads

  1. Replies: 189
    Last Post: 02-06-2025, 02:53 PM
  2. Replies: 293
    Last Post: 09-24-2020, 01:53 AM
  3. Appendix Thread. Diet Protokol Coding Adaptions
    By DocAElstein in forum Test Area
    Replies: 6
    Last Post: 09-05-2019, 10:45 AM
  4. Restrict data within the Cell (Data Validation)
    By dritan0478 in forum Excel Help
    Replies: 1
    Last Post: 07-27-2017, 09:03 PM

Posting Permissions

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