I was wondering if anyone could help me with some code to complete this task.
I have 2 worksheets "data1" and "data2" I want to search both sheets columns a - f, if any of the rows match exactly I want to copy the row to a sheet called "datamatch".
Thanks for any help.
I have 2 worksheets "data1" and "data2" I want to search both sheets columns a - f, if any of the rows match exactly I want to copy the row to a sheet called "datamatch".
Thanks for any help.