Imagine a data sheet containing values from A to AE. These values are
text and alpha/numeric.

What I want to accomplish is to capture the values contained in column
AE which are numeric by the top five costs. List those values into
another worksheet along with four other values associated with those
numeric values.

These "captured" categories would look something like this:

Costs - Customer - Department - Item -
PN



These top five costs are contained within the rawdata under column AE,
The customer data under N, Department under O, Item under P, and PN
under R.

thanks for the help from a total newbee.....


--
cebu2b
------------------------------------------------------------------------
cebu2b's Profile: http://www.excelforum.com/member.php...o&userid=31820
View this thread: http://www.excelforum.com/showthread...hreadid=515481