Creating separate spreadsheets from a master spreadsheet

[Bob]

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.

 

[Joel]

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

 

[Ron de Bruin]

Hi Bob

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