I have a workbook with 4 sheets.
On "Main" I have 3 categories and 6 buttons. The categories correspond with the heavy, medium, and light used belting sheets. The 6 buttons are simply Add & Remove belts. (2 for each category)
Mostly Like this...
What I'm looking for, is to make data entry extremely useful for the end user. Essentially clicking a button to add or remove a row from a data table. So they can click on "Add belt" and have input boxes pop up sequentially for them to enter data in.
This is what the data table looks like for the "Heavy Used Belting" sheet. https://i.imgur.com/y5xcakZ.png
The Data table range is C4:O1000
Here's the harder part for me though...
I would like "Add Belt" button on the "Main" sheet to find the next roll number, and automatically create it. So, all of the Heavy Used Belts have a roll prefix of "HU", Medium as "MU", etc... So when you click "Add Belt" under the heavy used category, it will find the next "HU" Roll #, and add 1 to it when it creates the row.
Here's the workflow I'm trying to achieve based off the data table as shown above.
Mostly, the point of this is to keep the end user out of the data table. The end users for this barely know how to use a flip phone, and I'd like to make this as easy as possible for them.. However, I'm not really sure the best way to go about this. Perhaps there's an even easier way that you guys may know of?
I would be so grateful for any help on this! I'm kinda stumped on it myself.
Thank you,
- First sheet is called "Main"
- Second Sheet Is called "Heavy Used Belting"
- Third Sheet Is called "Medium Used Belting"
- Fourth Sheet Is called "Light Used Belting"
On "Main" I have 3 categories and 6 buttons. The categories correspond with the heavy, medium, and light used belting sheets. The 6 buttons are simply Add & Remove belts. (2 for each category)
Mostly Like this...
- Heavy Used Belting
- Add Belt
- Remove Belt
- Medium Used Belting
- Add Belt
- Remove Belt
- Light Used Belting
- Add Belt
- Remove Belt
What I'm looking for, is to make data entry extremely useful for the end user. Essentially clicking a button to add or remove a row from a data table. So they can click on "Add belt" and have input boxes pop up sequentially for them to enter data in.
This is what the data table looks like for the "Heavy Used Belting" sheet. https://i.imgur.com/y5xcakZ.png
The Data table range is C4:O1000
Here's the harder part for me though...
I would like "Add Belt" button on the "Main" sheet to find the next roll number, and automatically create it. So, all of the Heavy Used Belts have a roll prefix of "HU", Medium as "MU", etc... So when you click "Add Belt" under the heavy used category, it will find the next "HU" Roll #, and add 1 to it when it creates the row.
Here's the workflow I'm trying to achieve based off the data table as shown above.
- User clicks "Add Belt" button on "Main" sheet for his desired category.
- Input Box = "Origin Location"
- Excel will automatically find the next available roll number and set it automatically
- Input Box = "Description"
- Input Box = "Length"
- Input Box = "Width"
- Input Box = "Total Weight"
- Input Box = "Price/lb"
- Input Box = "Price Paid For Whole"
- Input Box = "Comments"
- Input Box = "Date Received"
- Input Box = "SAP #"
- Input Box = "Purchase Order #"
- Input Box = "Location"
- A Message Box Pops Up and says "Your roll number is HU43" (<- example)
Mostly, the point of this is to keep the end user out of the data table. The end users for this barely know how to use a flip phone, and I'd like to make this as easy as possible for them.. However, I'm not really sure the best way to go about this. Perhaps there's an even easier way that you guys may know of?
I would be so grateful for any help on this! I'm kinda stumped on it myself.
Thank you,