Posts by VMAL

  • If specific word in 1 column, 5 adjacent columns get automated text

    Hi All,


    I have been trying to solve this problem but can’t seem to. I would be grateful if one of you awesome excel users would be able to help.
    I have attached a sample sheet below.
    What I’m trying to achieve is,
    If Column F is Yes then sheet stays as it is. E.g. Column F/ Row 4
    If Column F is No then Column G, H, I, J, K automatically come with the word N/A. E.g. Column F/ Row 5
    All your help will be truly appreciated.


    Regards,


    VMAL

  • If statements and automatic cell highlight if specific value

    Hi all,


    I fairly new to VBA and would be grateful if one of you could help me.


    I am trying to create a Macro to do the following.



    1. If column D, from row 10 to last row,
    · Value = 25 then column F on that row = 17.5
    · Value = 30 then column F on that row = 21.0
    · Value = 35 then column F on that row = 24.5

    .Value = 25 then column K on that row = 21
    .Value = 30 then column K on that row = 26
    . Value = 35 then column K on that row = 30

    § Value = 25 then column P on that row = 26.5
    § Value = 30 then column K on that row = 31.0
    § Value = 35 then column K on that row = 36


    2.
    Ø If column G, H & I is less than Col F on same row then highlight cell RED (Fail).
    Ø If column G, H & I is greater than Col F on same row then highlight cell GREEN (Pass).
    Ø If column G, H & I empty then highlight cell YELLOW (Missing).
    3.
    ü If column L, M & N is less than Col K on same row then highlight cell RED (Fail).
    ü If column L, M & N I is greater than Col K on same row then highlight cell GREEN (Pass).
    ü If column L, M & N empty then highlight cell YELLOW (Missing).

    4.
    § If column Q, R & S is less than Col P on same row then highlight cell RED (Fail).
    § If column Q, R & S I is greater than Col P on same row then highlight cell GREEN (Pass).
    § If column Q, R & S empty then highlight cell YELLOW (Missing).

    Point No. 2,3 and 4 are repetitive.


    I have attached a sample sheet.


    Once again Thank you for all your help.


    Regards VMAL

  • Copy & insert rows fom one sheet to another based on data in main sheet

    Hi all,
    I have been trying to solve this problem but can’t seem to. I would be grateful if one of you awesome excel users would be able to help.
    I have attached a sample sheet below.
    I have one main sheet called Project Details where I want to input all data.
    In the sub-sheets i.e (Jhon, Adam, Josh,Katy..etc) I only input the headers.
    I want to create a macro so that in the main sheet (Project Details) any Column from C to F that shows Jhon’s name, that whole row will be moved into Jhon’s sheet.
    For example, Row 7 shows Jhons name is cell C7 so I want the whole of row 7 from (A to O) to copy into Jhons sheet using the macro.
    Similarly, Row 8 shows Jhons name is cell D8 so I want the whole of row 8 from (A to O) to copied into Jhons sheet and so on.
    Since Jhons name isn’t in row 10, that row will not be moved into Jhons sheet.
    I hope that makes sense and one of you will be able to assist me.
    I am new to VBA, I created a macro but can’t seem to make it work.
    All your help will be truly appreciated.
    Regards,
    VMAL