Hi,
you can filter the information by item, then if you want to copy the
filtered information hightlight the filtered data, CTRL + G, special, visible
cells only, then CTRL + C, go to where you need to paste the information, and
paste it

"skr" wrote:

I have a worksheet of about 400 rows and 5 columns. Most of the data is
repeated with varying values. I need to calculate / separate data for each
item in the column. How do I do that? Iam using excel 2003. - for this
problem I tried to use the find command. But I am not able to save or copy
the data displayed. Any help is welcome.