creating multiple sheets, then individualized workbooks for each sheet

[acshipman]

Hello,

From a data sheet, which includes 60 reps with multiple accounts and

products, I need to create individualized workbooks for each rep, so
they would not be able to see each other's accounts. Each rep's
workbook should contain a drop box where they could switch between the
different accounts and possibly products.

I'm brand new at this - any ideas?

Thank you.

 

[Ron de Bruin]

Hi

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

 

[acshipman]

Hi

Start herehttp://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm







- Show quoted text -

Ron,

Thank you so much for all the great info. I got this project dumped on
me and I have no VBA skills, so I have a lot of work ahead of me.

Alina

 

[iliace]

If it's a data sheet, can you use a PivotTable to access it? This
would create the dropdowns to switch between different accounts, and
also products. You could use some VBA to prevent them from selecting
others' accounts. For example, if your datasheet were a table in a
database on a server (in Access for instance), you could use Excel to
query each rep's accounts (either entering credentials or current
login) and display the PivotTable for just their products from the
query.