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

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

Hi Bob

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


--

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


"Bob" <(E-Mail Removed)> wrote in message news:9C6A4F64-2C12-4141-A161-(E-Mail Removed)...
>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