I am confused and confounded (in over my head). I want to develop a Userform in Excel that will help me enter data into a Corrections Sheet Listing (First sheet in the Workbook). Excel in Office 365
1. I have four existing tables: Main Group (Interior and Exterior), Subgroup (12 items for Interior and 9 items for Exterior), Items Listing (with Subgroup Column Included), Corrections List (Specific corrections, with a CID number (Unique for each correction) and 1-6 corrections for each Item in the Items Listing).

2. I wanted to use cascading list boxes to drill down through the tables and select a proper correction: and put that correction in a text box on the Userform. Click on the Correction text in the Userform which would transfer it to a corrections form (Worsheet). Clicking on the Text box would transfer the text to the Worksheet, clear the Userform and start the process over again.

3. So far, I have the Main Group selection complete using and with a “Select Case” in the VBA Editor. I have a “Rowsource” Sub (Case is = 0 SubGroup.RowSource = "SubGroup_Exterior” and Case is = 1 SuGroup.RowSource = “SubGroup_Interior”) to populate the Subgroup List with one of the appropriate Subgroup Listings.

4. I have tried using “Index and Match” and “Index, Match and Match” and “Application.WorsheetFunction.” as part of my VBA. I cannot get the Item List and Corrections List to function or match with the Subgroup Lists.

Help please!