Copying All the visible Rows in the current sheet and pasting it to another sheet

Hy. i have a sheet on which i have created a list and a filter is set. when i choose some values from that list then certain values are shown(visible) and the rest is hidden. I just want to copy all the visible data(including all visible rows) from that sheet to another workbook.
i have used some code but it only selects first cell of the sheet. and i need All the visible rows to be copied to another workbook

Please Login or Register  to view this content.

Bingo That's All. waiting for the answer its urgent.

Hi

See if this, helps you.

http://www.excelforum.com/july-compe...-formulas.html

If you need to do this,ONLY using Macro, then OK.

But you saw only the filters in Sheet 1. Did you see Sheet2?

Good luck.

Did you try

Please Login or Register  to view this content.