Alas, this is not working out the way I thought it was. The file that
orginally was working with had only two columns, Item and Description
The macro is counting the number of same items in column a and mergin
ok, but the new spreadsheet I have to work with has a third column wit
quantity as well.

So running the macro on this is throwing the quantities totally out o
whack.

It's difficult to explain, attached is an example of what I am takin
about.

I hope someone can help out!

Thanks

+----------------------------------------------------------------
| Attachment filename: wtnov.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=363516
+----------------------------------------------------------------

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com