View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DanS DanS is offline
external usenet poster
 
Posts: 5
Default Match value from column A to column A on 2nd sheet and then copy R

I am looking to do something like this

For value in Sheet1(Column A) match to value in Sheet2(Column A) and then
copy Entire Row containing match from Sheet2 only once After lastrow on
Sheet1 even if there are multiple cells with the same value on sheet1.