Tom-Your solution to my problem was AMAZING and worked PERFECTLY. On
favor, however. I might be able to figure this out on my own, but
really don't want to screw up your awesome code. The output right no
is giving me:

Item Number
Slot Number
Description
Item Number
Slot Number
Description

Or, to refer back to my example from my original post:

5301
DF212
Black Beans
5301
DF212
Black Beans

...etc., etc.

What would I need to change to have it list in the following order:

Item Number
Description
Slot Number

Or, again, referring to my original post:

5301
Black Beans
DF212

Thanks again for your incredible solution to this nightmare!!!!

Jim Carpente

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

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements