What do you consider as a "spreadsheet"?

A workbook or a worksheet?

Whichever see Ron de Bruin's site for code.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP


On Thu, 6 Aug 2009 03:27:02 -0700, Beginner for Macro
wrote:

I want to extract information displayed after filter to another spreadsheet.
Can anyone help me to write a macro for that please?

A simple copy and paste can be used but I have to abstract data out og
number of spreadshhet for number of report and its getting tedious.

Thanks.