Thanks for the reply Brian and Bruce.

I think Bruce hit on the head when he mentioned which version. I'm
using Excel 2000, from the office 2000 package. Unlike your Brian,
when I copied and paste the sheet after applying the filter it pasted
the hidden fields as well in the new sheet.

I ended up finding the answer how to fix the problem, which is as
follows. (Hopefully someone else will need the solution)

After applying the filter and before copying the data, hit F5 and then
click special, then place a mark in the "visible cells only" radio
button. Now when you copy and paste the data, only the filtered results
will be on the new sheet.

Thanks again for the replies!

Robert