userform to store employee numbers...

[Guest]

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.