New WorkBook
 

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

Hi

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ACase" wrote in message ...
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