View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default creating multiple sheets, then individualized workbooks for each sheet

Hi

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


--

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


wrote in message ups.com...
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.