ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userform to store employee numbers... (https://www.excelbanter.com/excel-programming/353719-userform-store-employee-numbers.html)

jeramie[_2_]

userform to store employee numbers...
 
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

userform to store employee numbers...
 
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" wrote in message
...
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!!






All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com