stevenmgroves
New Member
- Joined
- Apr 30, 2014
- Messages
- 1
Where I work I have to keep tabs on over 200+ multifunctional printers. The Toner requests & Service Call Requests each machine. What they had previously is just manually inputting the data each time. I am wanting to somewhat automate that.
My Idea:
Create a Excel File that has a main tab with all the devices ID numbers, site name, location, IP address, and other things. I will have two tabs at the bottom: One for Service Request & One for Toner Requests. I am wanting to create a userform that allows the user to enter in the printers ID number and it will display all the information about the printer that is in the main tab on this userform. Allow them to select Service Call or Toner Request and depending on which one they select, certain pieces of information would go into the specific spreadsheet for later viewing.
Conclusion:
Wanting a userform that will Search as well as Store information in one of two workbooks.
IS THIS POSSIBLE??
My Idea:
Create a Excel File that has a main tab with all the devices ID numbers, site name, location, IP address, and other things. I will have two tabs at the bottom: One for Service Request & One for Toner Requests. I am wanting to create a userform that allows the user to enter in the printers ID number and it will display all the information about the printer that is in the main tab on this userform. Allow them to select Service Call or Toner Request and depending on which one they select, certain pieces of information would go into the specific spreadsheet for later viewing.
Conclusion:
Wanting a userform that will Search as well as Store information in one of two workbooks.
IS THIS POSSIBLE??
