New WorkBook

[Guest]

Hello,

I have a workbook which has 2 worsheets. The first contains data in Table
format. The second is in report format and links to the data.

I would like to create a macro which creates a new workbook and loops
through the data worksheet creating a new worksheet report based upon the
data.

So for example lets say the data worksheet contained revenue for each month
(12).

The new workbook would contain 12 tabs. Each tab would be a seperate
monthly report.

Any help would be much appreciated.

Thanks
Acase

 

[Ron de Bruin]

Hi

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

Maybe you like EasyFilter
http://www.rondebruin.nl/easyfilter.htm