Team, daily I need to do data validation comparison between source and destination table more than thousands of records coming each table. Like wise I need to check daily for 5- 6 table with 23-24 columns having 1000-3000 records using excel. Daily I'm using vlookup to validate manually. Could you please suggest how to write a macro's for these kind of validations