Creating separate spreadsheets from a master spreadsheet
 

I would like to know if there is a way to create individual spreadsheets from
a master spreadsheet thru a macro.? For example, my master spreadsheet has 10
salesmen listed and I would like to have a spreadsheet for each salesman.

Thanks.
--
Bob

Creating separate spreadsheets from a master spreadsheet
 

It is usually very simple. You have not provided enough details to supply
code.

for example


for ColCount = 3 to 10
worksheets.add after:=Sheets(Sheets.count)
sheets("Master").column(ColCount).copy _
activesheet.columns("A:A")
Activesheet.name = Sheets("Master").cells(1,ColCount)
Next ColCount


"Bob" wrote:

I would like to know if there is a way to create individual spreadsheets from
a master spreadsheet thru a macro.? For example, my master spreadsheet has 10
salesmen listed and I would like to have a spreadsheet for each salesman.

Thanks.
--
Bob

Creating separate spreadsheets from a master spreadsheet
 

Hi Bob

See
http://www.rondebruin.nl/copy6.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bob" wrote in message ...
I would like to know if there is a way to create individual spreadsheets from
a master spreadsheet thru a macro.? For example, my master spreadsheet has 10
salesmen listed and I would like to have a spreadsheet for each salesman.

Thanks.
--
Bob