yeah sorry -
ive had trouble trying to explain before.
what i would love to do is -
have a summary sheet within the workbook that lists only what has been
ordered from the other worksheets (tees, walkshorts, etc)

how would you get excel to read each worksheet, realise that 1pack of
Sin City tee shirts and 1 pack of walk shorts had been ordered but
nothing else and put those two packs on the summary sheet.
so the results are completely based on what the end user types in -

the goal here is that the end user can fill in the entire order form
(all four sheets) and then only have to go the summary sheet to see
what he/she has ordered and what the total is...

hope this makes a little more sense hahahha.
thanks for helping - looking


--
George.
------------------------------------------------------------------------
George.'s Profile: http://www.excelforum.com/member.php...o&userid=35028
View this thread: http://www.excelforum.com/showthread...hreadid=547768