Here is my challenge.
I receive about 20 pricelists from various computer suppliers with component pricing.
I would like to compile one pricelist out of all of them.
The challenge is however that that the sheets are not formated the same.
Some suppliers go: ItemCode| Price | Description...
I have two worksheets from two different sources that contain mailing addresses. I need to compare the two worksheets and separate the addresses that have no match. I have looked at a macro that gave me a quarter of what should be there. Please help!
I am going to create a workbook to do a comparison between two different workbooks so I do not have to open the other workbooks, and I was wondering, can I make it change the coloring of the cell and show the contents of the cell?
WB1 will always be the newer workbook, so changing the formula...
Workbook 1 (name varies)--> Worksheet 1 --> Column A --> Cell 2 thru (varies - can be hundreds or thousands)
Workbook 2 (Rlistsort) --> Worksheet 1 --> Column A --> Cell 2 thru (currently 250 but will continue to increase)
Need to compare Column data in Workbook 1 to Data...