userform to store employee numbers...

[jeramie]

I have a template that mey get distributed throughout our company (over
15,000 employees, or there-abouts), If I can get it to work. I have a
multipage userform, and want the managers to be able to enter the employee
names/numbers in the userform (page1), and have it "store" them. Then, when
the employee enters their name into the worksheet, their number is added
automatically entered from "storage". I would also like the names/numbers to
be removed (in case if dismissal) through the userform on page2. BTW-
names go in A3, numbers in C3. thanks for any help.


P.S. any idea how i can get them to buy it from me? Royalties from near
45000 pages per day could be nice!!

[Tom Ogilvy]

Generally information is stored on a worksheet. Entry may be made through
your userform.

You could add their number in C3 using a vlookup formula refering to the
worksheet where you have stored the data entered by the managers.


Work done while employed by the company generally belongs to the company.

--
Regards,
Tom Ogilvy



"jeramie" <jeramie@discussions.microsoft.com> wrote in message
news:583009A7-E5D2-46D5-8F0A-5CCA3A5E9A88@microsoft.com...
> I have a template that mey get distributed throughout our company (over
> 15,000 employees, or there-abouts), If I can get it to work. I have a
> multipage userform, and want the managers to be able to enter the employee
> names/numbers in the userform (page1), and have it "store" them. Then,
when
> the employee enters their name into the worksheet, their number is added
> automatically entered from "storage". I would also like the names/numbers
to
> be removed (in case if dismissal) through the userform on page2. BTW-
> names go in A3, numbers in C3. thanks for any help.
>
>
> P.S. any idea how i can get them to buy it from me? Royalties from near
> 45000 pages per day could be nice!!
>
>