I have 2 workbooks that I need to compare data in. The issue is that the 2 workbooks will not always be the same name and one of the workbooks will have sheets within it,
What im trying to do is look in workbook 1 on a specific sheet and compare the data with workbook 2 and that is on one sheet only. If the data is on the specific sheet in workbook 1 and also in workbook 2 thats fine but if data missing in workbook 2 then I need that data in workbook 1 highlighted in yellow.
I also need the data to be an exact match in columns A-D but the issue is that there may be data on line 1 in workbook 1 and the same data in line 44 in workbook 2 so I need it to look right down workbook 2 to match.
Can I set up a macro to do that and also when I first start it it ask me where to look for the data I need to compare? Unfortunally my macro knowledge is restricted to recording on excel.