Hi All,
Thank you various supporting by so many good people in this forum for my earlier queries. Here i have another peculiar issue (may be for myself only). I have tried to find out various solutions, but could not implement properly. The requirement is explained below:
I have two sheets with names "Download from Tool" and "Download from System".
Both have unique ID in column "F".
Rows in sheet "Download from Tool" starts from "A8" (Always), list of projects may go upto 100.
Rows in sheet "Download from System" starts from "A2" (always), list of projects may go upto 100.
*Note: sheet structures should remain as is. If named ranges are used for data handling, it would be nice for adjustment of data range which i am comfortable.
1st Requirement is all unique ID's will have to be copied (from A to O from both sheets) to "Final Data" sheet.
2nd requirement is for each unique id matched row, compare each cell of "Download from System" sheet w.r.t to same unique ID row in sheet "Download from Tool". Highlight the differences in "Download from System".
Hope fully my explanation above is understandable. I am attaching work sheet example, in which i have highlighted few examples (Unique IDs, AP-26610006, AP-21310003, AP-21311016 ) in sheet "Download from System".
Kindly suggest suitable code. Thanking you in advance
Best Regards,
Narasimharao
Bookmarks