Posts by mohammedismail

    Re: Search Through each cell in column and delete column if empty

    Try the below !

    Re: Quickest way to paste entire rows depending on criteria

    Try the below and let me know if you face any issues !

    Re: Clean A Large Spreadsheet with VBA

    Without getting into simplifying your code, here are 2 lines which you should add before filtering for NA then it will work faster !

    Columns("A:A").Sort key1:=Range("A2"), _
    order1:=xlAscending, Header:=xlYes

    Re: Delete Cells that have Number Format Currency

    Quote from grame22;751525

    Here is my file.

    Thank you.

    Here is my code :)

    Re: Work book help

    Try below !

    Re: Work book help

    Try the below and let me know if it helps !

    Re: Combining vlookups

    Column G to L is 6 Columns, you have mentioned as 5 ? You might want to change to the below !


    I think you are looking for something like the below formula.

    This will first check Column A:D, if it returns NA then it check column G:L and returns the value.


    Re: Code to change data format from mm/dd/yyyy hh:mm to dd/mm/yyyy hh:mm

    Slight changes to your code!

    Please use the below how ever you want !

    'Insert column to the left of the active cell
    'Insert column to the right of the active cell
    ActiveCell.EntireColumn.Offset(0, 1).Insert

    Re: VBA to move multiple data from columns to rows

    See the below code, let me know if you face any issues !

    Re: Adding values adjacent to certain values in a list

    Here is the formula for Developed Countries.


    Formula for Emerging Markets !

    [BFN]=SUM(SUMIFS($C$1:$C$12,$A$1:$A$12,{"Hong Kong/China","Thailand","Mexico","Australia"}))[/BFN]