Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to filter to a new workbook for exceptions of potential
mischarges, by comparing a Table of Actual Charges Vs a Table of Allowed Charges by Employee and Project. The Table of Actual Charges may vary, plus or minus for Employees or Projects. .. Workbook A Sheet1 - Table of Allowed Charges. Employee Project W Project X Project Y Project Z Emp A Y Y Emp B Y Y <--- "Y" stands for allowed. Emp C Y Emp D Y .. Workbook B Sheet1 Table of Actual Charges [With a twist : One new Employee, One new Project] Employee Project V Project X Project Y Project Z Emp A 140 20 Emp B 80 60 20 Emp C 70 90 Emp E 40 120 .. Worbook C Sheet1 Table of Potential Mischarges, resulting from Workbook B Sheet1 Actual Charges, not matching Workbook A Sheet1 - Table of Allowed Charges. Employee Project V Project X Project Y Project Z Emp B 80 60 Emp C 90 Emp E 40 120 .. From this result table, I would update Workbook A Sheet1, if charges are justified. Help appreciated J.P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I compare two worksheets using Excel? | Excel Worksheet Functions | |||
Excel VBA Macro to compare 2 worksheets for same values | Excel Worksheet Functions | |||
Compare 2 similar excel worksheets | Excel Worksheet Functions | |||
How to file compare Excel worksheets | New Users to Excel | |||
How do I compare two Excel worksheets for cell differences? | Excel Discussion (Misc queries) |