Hi,
Have two Workbooks (1 Sheet in each) and was wondering whether the following is possible?
Each 'workbook' has;
Column 'A' - Unique employee pay number; (there may be more than one entry for the employee but column's 'x' and 'Y' are different in these cases
Column 'X' has date;
Column 'Y' has date; (Different from 'X')
Each workbook mirrors each other in number of columns/headings. The data is extrapolated from a database and can have up to 5000 rows of data on each sheet.
Trying to have row highlighted in Workbook 2 where;


I am not sure whether a VBA script would be the right way to go about this problem so any advice would be appreciated.
Have two Workbooks (1 Sheet in each) and was wondering whether the following is possible?
Each 'workbook' has;
Column 'A' - Unique employee pay number; (there may be more than one entry for the employee but column's 'x' and 'Y' are different in these cases
Column 'X' has date;
Column 'Y' has date; (Different from 'X')
Each workbook mirrors each other in number of columns/headings. The data is extrapolated from a database and can have up to 5000 rows of data on each sheet.
Trying to have row highlighted in Workbook 2 where;
- Data in column 'Y' differs between Workbooks (i.e. different date in Workbook 2 opposed to Workbook 1 where date has been changed between audits)
- Data in Workbook 1 that is not in Workbook 2 (i.e. where data row has been 'deleted' between audits)
- Data in Workbook 2 that is not in Workbook 1 (i.e where data has been 'added' to database between audit dates)


I am not sure whether a VBA script would be the right way to go about this problem so any advice would be appreciated.
