Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Two Workbooks
Hi,
I have two workbooks with data in them that I need to do a funky comparison to. Workbook01 Col A has Items that are more than likely sold and there are multiple duplicates for some items. Workbook02 has the same thing in Col G but Col F also has "Sold" or "Not Sold" or nothing in it at all. I would like to use Workbook01 as the main workbook and have some sort of code or statement that will compare the two and for each match it finds it will then then check if workbook02 has a "Sold". If it's a one-for-one match as well as "Sold" then in Col K of workbook01 it highlights each instance green. If it's anything other than sold and/or if there is a quantity difference; then in workbook01 it highlights Col K of each nonmatching item yellow as well as puts a note in Col K next to each instance of that item that says how many there are in workbook01 and how many there are in workbook02 as well as how many say sold in workbook02. Is this possible and if so can someone help me? Thanks Sooo Much In Advance, Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two workbooks. | Excel Worksheet Functions | |||
Comparing Workbooks | Excel Discussion (Misc queries) | |||
comparing workbooks | Excel Discussion (Misc queries) | |||
Comparing data on 2 workbooks | Excel Worksheet Functions | |||
Formula for comparing text in two workbooks | Excel Worksheet Functions |