Copying filtered lines into another sheet?

[DesperateDan]

Hey guys,

Fairly new to excel. I have a worksheet 1 populated with information. I filter the required information and copy it.

I then open another page, page 2, still in the same work book, and I want to paste the copied info into this sheet. When I do hit paste, it pastes the entire workbook from page 1.

I then tried it again, and instead of “pasting” I selected “insert copied cells” these does provide me with the required information but the only thing it duplicates the same information over and over again all the way down the workbook!

How can I copy the filtered lines from workbook 1 and post them exact lines into another workbook without anything else??

Thanks for your help and patience guys.

?

 

[Michael M]

Selectthe range of cells>>Home Tab>>Editing Tab>>Find & Select>>Goto Special>>"Visible cells only""
Copy and paste to new location

 

[kevin9999]

Could you provide a copy of your data using the XL2BB Tool, as well as an indication of what exactly you want to copy to the second sheet?