Scenerio:
I have one large spreadsheet that I created for all the leads I receive
for 12 outside sales reps.
What I want to do:
I want to have this spreadsheet on our shared drive but have it so that
if an outside sales rep logs in with his specified password that he only
see's his own leads.
Currently doing:
Cutting and pasting to seperate workbooks so that they only can see
their information and emailing to them.
Problem:
Lots of time used to cut and paste

Question:
Is there a way that excel can do this? Multiple users all having access
to one spreadsheet with all information but only seeing their
information.


--
jeffk
------------------------------------------------------------------------
jeffk's Profile: http://www.excelforum.com/member.php...o&userid=36334
View this thread: http://www.excelforum.com/showthread...hreadid=561215