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 !


    Code
    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 !


    [BFN]=VLOOKUP(A2,Scheduled!G:L,6,0)[/BFN]


    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.


    [BFN]=IFERROR(VLOOKUP(A2,Scheduled!A:D,4,0),VLOOKUP(A2,Scheduled!G:L,6,0))[/BFN]

    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 !



    Code
    'Insert column to the left of the active cell
    ActiveCell.EntireColumn.Insert
    
    
    
    
    '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.


    [BFN]=SUM(SUMIFS($C$1:$C$12,$A$1:$A$12,{"USA","Germany","UK","Switzerland","France","Finland","Netherlands","Belgium"}))[/BFN]


    Formula for Emerging Markets !


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