Posts by xchorok

    HI all,


    I've been looking all previous threads to find my answer, however most of the macros are for Outlook (I need one for Excel).


    Is there Excel Macro to 'Reply to the currently opened email'?


    Hi team,


    I've create a long macro to filter by Date and return the number of visible rows - however this is not working somehow.


    Also, I want my code to be shorter if possible.


    Could you please help me to generate a better code?


    I have attached 2 files - One to run the macro and one for Sample Data Book.






    Thank you!

    Hi team,


    I am unsure if my problem can be solved using Excel VBA, however I will give it a try.


    I have a really long formula as below.


    My ultimate goal is to make this formula short.


    The formula is written to write Yes if Last 3 digit numbers of Table Number and the Team color is matching.

    (For example, as per the table in Data Tab, Team Color must be Blue if last 3 digit numbers of Table Number is 135. Team Color must be Green if last 3 digit numbers of Table Number is 118.)


    Can any VBA Master help me to achieve below:

    1. I want to use the table in Data Tab, instead of keep making the formula long and big.
    2. I want to apply this formula whenever I update the table in Data Tab (I can add/delete/update numbers and Team Colors in future.)


    Below is my current code, and I am attaching the file for your attention.



    Thanks!

    Files

    • Book1.xlsm

      (31.06 kB, downloaded 25 times, last: )

    Thank you Carim!


    I tested it, and I noticed there are 2 things I want to discuss with you:


    1. When I tried, it did not allow me to update the blank cells - instead, it replaces all.


    (For example, when I want to just update Phone Number and Mobile Number for Ellen, it removes all previous information and only adds Phone Number and Mobile Number.)


    I will just remove my request to replace cells with new data in "Template" sheet, but want to change to 'update blank cells only'.


    Can you please help me to generate macro code to update blank cells only?


    2. I want to change the Macro to compare First Name and Last Name in "Template" sheet with the First Name and Last Name in "Contact Details" sheet.



    I am attaching my previous data and code again for your help.


    Thank you!


    Hi team,


    I've looked up all previous threads to find similar code, however could not find one.


    I want to compare First Name in "Template" sheet with the First Name in "Contact Details" sheet.


    If there is matching one, I wan to update any blank cells (or replace with new data in "Template" sheet) in "Contact Details" Sheet.


    If there is no match, I want to add another row in "Contact Details" sheet.


    Below is what I have tried, and I am attaching the spreadsheet as well.


    Thank you!


    Files

    • Book1.xlsm

      (20.61 kB, downloaded 25 times, last: )

    Hi team,


    I would like your help to create macro to create hyperlink between worksheets.


    I tried below, however it is not working.


    Would anyone please help?


    I tried Vloopup and Hyperlink but it does not work as well (=HYPERLINK(VLOOKUP(A7,Instructions!A:A,1,FALSE),"LINK"))





    Thank you!

    Files

    • Book1.xlsm

      (17.77 kB, downloaded 22 times, last: )

    I've tried below as well..


    Below is something I tried to do:


    Hi all,


    I need your help to create macro:


    "Sheet1" has data below:


    Tag CHECK
    Check No Number 3
    Countries
    Slovakia
    Poland
    Germany
    France
    United Kingdom
    Indonesia




    "Sheet2" has below data:


    Check No Number 1 Number 2 Number 3 Number 4 Number 5
    Countries
    Bulgaria
    Cyprus
    Finland
    France
    Germany
    Hungary
    Italy
    Luxembourg
    Netherlands
    Poland
    Portugal
    Romania
    Slovakia
    Spain
    United Kingdom


    I want to add Tag (in this case, "CHECK") to matching intersection cells in Sheet2.

    If there is no data in Sheet2, then I wan to add another Row at the end of the data. (In this case, Indonesia is not on Sheet2, I want to create new row for Indonesia).


    The desired outcome:



    Check NoNumber 1Number 2Number 3Number 4Number 5
    Countries
    Bulgaria
    Cyprus
    Finland
    France CHECK
    Germany CHECK
    Hungary
    Italy
    Luxembourg
    Netherlands
    Poland CHECK
    Portugal
    Romania
    Slovakia CHECK
    Spain
    United Kingdom CHECK
    IndonesiaCHECK



    The Countries will be changed every week, and Tag can also be changed.


    So, if I want to change the Tag to ALERT and I want to add this Tag to some countries (Italy, Poland, France and Spain) under Check Number 4;


    The desired outcome:




    Check NoNumber 1Number 2Number 3Number 4Number 5
    Countries
    Bulgaria
    Cyprus
    Finland
    France CHECK ALERT
    Germany CHECK
    Hungary
    Italy ALERT
    Luxembourg
    Netherlands
    Poland CHECK ALERT
    Portugal
    Romania
    Slovakia CHECK
    Spain ALERT
    United Kingdom CHECK
    IndonesiaCHECK



    Anyone can help me?


    Thank you!