HI Lisa,

thanks for your response, I dont think I explained the problem
properly, I have a worksheet A1:IV600, in column A1:A600 I have one
name per row, in columns B:IV i have the product codes, I have entered
data by row in the corresponding product column (there is a minimum of
one and maximum of 17 ) entries or cells filled per row accross the 250
columns, thus leaving lots of blanks, I want to copy the data, or
products each person has bought into a smaller worksheet, i.e. reducing
the 250 columns to 18, how do I avoid copy of blank cells

Lorraine


--
lorraine knight
------------------------------------------------------------------------
lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294
View this thread: http://www.excelforum.com/showthread...hreadid=551034