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)