View Single Post
  #1   Report Post  
BMX19
 
Posts: n/a
Default How do I copy filtered rows in excel

I am running Microsoft Excel 2002, the problem I am having is I have a whole
database of information with the top row being a fileter for each inidividual
column, so that I can find specific information in that column when I filter
som information so that my data is listed in the rows only with the relevant
information the rows go from (ex. 121,134,156...) with the inbetween lines
being invisible, the problem is that when I try to copy/cut a group of these
filtered lines I can do it and than paste the information into my new sheet
and only the copied/cut lines will appear but when i go back to the original
sheet the invisble lines that i did not select are also missing. Does anyone
know how I prevent this. Thanks for your help