justdream
06-02-2012, 02:38 AM
Dear Experts,
Kindly help me - I’m searching for tool or Excel VBA Macro to do Workbook Parameters compare based on below criteria:
- Each workbook (old & new) has several sheets with unique names “Sheet_1 to be compared with sheet_1, etc”
- Comparison will be based on common factor (which exist in each sheet in Column called Area Name) however this column index is not fixed per sheet_number “For example in sheet_1 for both workbooks it’s in 2nd. Column for sheet_2 it’s in 3rd. column”
- Hereby, compare to be for cells right to column Area Name
- Items under Area Name not exactly sorted for both workbook (so tool should not compare row1 with row1)
- Output could be as in below links
- Please note that number of sheets is not only 2, it could be more/ same for rows
http://www.2shared.com/file/0fTGOe6j/w_compares.html
Kindly help me - I’m searching for tool or Excel VBA Macro to do Workbook Parameters compare based on below criteria:
- Each workbook (old & new) has several sheets with unique names “Sheet_1 to be compared with sheet_1, etc”
- Comparison will be based on common factor (which exist in each sheet in Column called Area Name) however this column index is not fixed per sheet_number “For example in sheet_1 for both workbooks it’s in 2nd. Column for sheet_2 it’s in 3rd. column”
- Hereby, compare to be for cells right to column Area Name
- Items under Area Name not exactly sorted for both workbook (so tool should not compare row1 with row1)
- Output could be as in below links
- Please note that number of sheets is not only 2, it could be more/ same for rows
http://www.2shared.com/file/0fTGOe6j/w_compares.html