Hi ive looked all over the internet and totally confused now.
What it is I have 2 workbooks open and they have sheets within it.
What im trying to do is look at the sheet I have selected within workbook 1 and then automatically check that against the sheet I have selected in workbook 2 and if there is no data in workbook 2 but there is in workbook 1 I need the row highlighted.
Workbooks 1 & 2 do not have data all layed out in the same order BUT does have column headers of which is NLC/MACHINE/DATE/AMOUNT.
When looking down workbook 2 to see if there is a match with workbook 1 DATA MUST BE AN EXACT MATCH across all columns and they may not be in the same row number so I need it to look all the way down workbook 2 to see if there a match.
I was told that I can compare data within 1 workbook but im trying to compare against 2 workbooks and not copy and paste anything because of size of files.
I know there are online comparers but need to have it saved to a workbook so donno if it can be done as a macro or something else??
Any ideas?
What it is I have 2 workbooks open and they have sheets within it.
What im trying to do is look at the sheet I have selected within workbook 1 and then automatically check that against the sheet I have selected in workbook 2 and if there is no data in workbook 2 but there is in workbook 1 I need the row highlighted.
Workbooks 1 & 2 do not have data all layed out in the same order BUT does have column headers of which is NLC/MACHINE/DATE/AMOUNT.
When looking down workbook 2 to see if there is a match with workbook 1 DATA MUST BE AN EXACT MATCH across all columns and they may not be in the same row number so I need it to look all the way down workbook 2 to see if there a match.
I was told that I can compare data within 1 workbook but im trying to compare against 2 workbooks and not copy and paste anything because of size of files.
I know there are online comparers but need to have it saved to a workbook so donno if it can be done as a macro or something else??
Any ideas?