So I have a workbook that I use new daily, I also have a workbook I keep with a runnning collection of the data that I currently send "New" records to every day.
I am trying to figure out how to match column A and Column L, then if both are an exact match copy the cell in column T from workbook1 and paste into the matching row of workbook2 column T.
Both are tables and both are matching layouts but i can tweek to fit that if I can just figure out the "If Match by both criteria copy and paste"
As always any help is greatly appreciated
I am trying to figure out how to match column A and Column L, then if both are an exact match copy the cell in column T from workbook1 and paste into the matching row of workbook2 column T.
Both are tables and both are matching layouts but i can tweek to fit that if I can just figure out the "If Match by both criteria copy and paste"
As always any help is greatly appreciated