Posts by yuvarajprince17

    I have two sheet of Excel one is dailyextracted data & other one consolidated data

    I want a VBA for daily extracted data on one click below 3 points to be actionable till the last row of extract sheet (last row count may change day to day) & consolidated data will get add daily (vlookup should check complete data & to give result for only fresh case)


    1) Column E, H & I - time to be removed should give only date


    2) Column M need to concatenate result of Column BCHGJ


    3) Column N to have vlookup result from consolidate data refering to concatenate not found it should show as "latest dump" (other sheet will have compiled data of daily extracted data & concatenate will be in first column)