From One Book to many book macro for monthly report

[cometorta]

Hi,

I need to write a macro starting with a data dump from one excel workbook and create several different workbooks based on sales region id. Can anyone suggest how i can accomplish data.

The number of sales region ids increase and decrease every month so I will need a smart code to create equal number of workbooks as the number of unique sales region ids everytime the macro is run.

The original workbook has the following data structure:

Sales Region ID Sales
1 20
1 15
2 5
3 7
3 3

So my end product needs to be 3 differenct workbooks.

thanks in advance for the help,

Sincerely,

Francisco

 

[VoG]

Hello and welcome to MrExcel.

See if this helps http://www.mrexcel.com/forum/showthread.php?t=396069