![]() |
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!! |
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