DavidNithin
02-23-2020, 02:15 AM
Hello,
I have two different excel workbooks. Where I need to check one column with the other in another workbook. I need to check whether one column data is available or not in the second file and if available check for differences in data and highlight differences in the second sheet and if not available highlight the data in the first sheet or vice versa.
My problem is both the excel workbook are not in the same format. So for starter, I want to compare one column (which,if possible, I want to select dynamically ) with the (any)column in the other workbook (if possible dynamically) and highlight changes. Here Dynamic selection will allow me to discard the different format of the workbooks.
I'm a complete beginner and all the VBA codes I've used till now are courtesy of Google and VBA forums. So I'm not sure if this is possible at all when I have the workbooks in different formats. Please let me know your suggestions.
I have two different excel workbooks. Where I need to check one column with the other in another workbook. I need to check whether one column data is available or not in the second file and if available check for differences in data and highlight differences in the second sheet and if not available highlight the data in the first sheet or vice versa.
My problem is both the excel workbook are not in the same format. So for starter, I want to compare one column (which,if possible, I want to select dynamically ) with the (any)column in the other workbook (if possible dynamically) and highlight changes. Here Dynamic selection will allow me to discard the different format of the workbooks.
I'm a complete beginner and all the VBA codes I've used till now are courtesy of Google and VBA forums. So I'm not sure if this is possible at all when I have the workbooks in different formats. Please let me know your suggestions.