LinkBack URL
About LinkBacks
Hello,
Can someone pls. assist me in creating a macro that would compare two worksheets and their differences would be copied into a third worksheet in the same workbook? Several key criteria is needed:
1) The third worksheet would need to note only the data from the 1st and 2nd worksheets (including headers) that had differences. An additional column would do the difference calculations for the data whereby numeric values are subtracted (worksheet 2 from worksheet 1 values) and non-numeric values would note "Pass" or "Fail".
2) All data values that had differences would be formatted in yellow shading on the third worksheet.
3) The unique ids from column A in worksheet 1 would have to have be noted in column A of the third worksheet; even if they didn't have a difference from worksheet 2.
4) The third worksheet would need to note all of the columns noted in worksheet 1 and include the difference column for each unique column.
5) Flexibility in code to allow for addition of new columns to analysis.
Pls. see attached sample spreadsheet whereby Worksheet 1 = "dv file", Worksheet 2 = "price file" and Worksheet 3 = "Error" for purposes of this discussion.
Thank you in advance.
Register To Reply
Bookmarks