Hello all,
I am trying to create a tool which will allow my clients to easily navigate through our on-boarding process; however, it's becoming a headache for me.
I'm open to VBA suggestions, I just need to know what to do.
Sheets:
CAT SUBCAT
FAULTS
Starting in in CAT SUBCAT, cell A2, the User will manually create/type categories for their enterprise.
In CAT SUBCAT, cell B2, the user will assign Sub Cats to their Categories.
There could be hundreds of rows of data.
IE:
COLUMN A: COLUMN B:
<colgroup><col><col></colgroup><tbody>
</tbody>
Once a user has input their data, I want them to create a dynamic lists based of the data.
On Sheet FAULTS,
I need FAULTS.A2 to have a drop-down list of of all unique values from CAT SUBCAT Column A, and FAULTS.B2 to have a dependent drop down based off the users selection in FAULTS.A2, so the user can then manually type in a fault code into FAULTS.C3.
I don't want the user to have to name ranges/lists, so I need to do this via formulas, or VBA.
I hope that this make sense.
Thank you for your help.
I am trying to create a tool which will allow my clients to easily navigate through our on-boarding process; however, it's becoming a headache for me.
I'm open to VBA suggestions, I just need to know what to do.
Sheets:
CAT SUBCAT
FAULTS
Starting in in CAT SUBCAT, cell A2, the User will manually create/type categories for their enterprise.
In CAT SUBCAT, cell B2, the user will assign Sub Cats to their Categories.
There could be hundreds of rows of data.
IE:
COLUMN A: COLUMN B:
BAKERY EQUIPMENT | AIR BRUSH |
BAKERY EQUIPMENT | DOUGH DIVIDERS |
BAKERY EQUIPMENT | GLAZERS |
BAKERY EQUIPMENT | MIXERS |
BUILDING AND GROUNDS | ACCESS HATCH |
BUILDING AND GROUNDS | AWNINGS / CANOPY |
BUILDING AND GROUNDS | BENCH |
COMMUNICATIONS | PAGING SYSTEM |
COMMUNICATIONS | PHONES |
HOT FOODS EQUIPMENT | DEEP FRYERS |
HOT FOODS EQUIPMENT | HEAT LAMPS |
PLUMBING | BACKFLOW |
PLUMBING | DISPOSALS |
PLUMBING | DRAINS |
PLUMBING | EXTERIOR MAIN SEWER |
PLUMBING | FAUCETS |
<colgroup><col><col></colgroup><tbody>
</tbody>
Once a user has input their data, I want them to create a dynamic lists based of the data.
On Sheet FAULTS,
I need FAULTS.A2 to have a drop-down list of of all unique values from CAT SUBCAT Column A, and FAULTS.B2 to have a dependent drop down based off the users selection in FAULTS.A2, so the user can then manually type in a fault code into FAULTS.C3.
I don't want the user to have to name ranges/lists, so I need to do this via formulas, or VBA.
I hope that this make sense.
Thank you for your help.