Trying to use VBA to get the information input on one sheet to populate a table on another sheet.

[aoldenburg83]

Hello everyone! I am trying to figure out what VBA code to start with here.

I have a sheet titled "Job Type (Start)". In this sheet, the user will input information from the form in the screenshot. Obviously the checkboxes work as true/false, and the rest of the blue cells are dropdown lists, a combination of both text and num.

On a second sheet, called "Scope (Field)", I would like to pre-populate cells in a table based on the information in the job type sheet.

For instance, if someone chooses a remediation job type, and checks true to the dry ice blasting, I would like it to populate the beginning of the table with specific information.

Is this possible? I know it must be, but I am simple not well versed enough yet to understand how to write it.

Any help would be appreciated, thank you!

 

[OaklandJim]

This seems straightforward. I'd bewilling to try to assist but you'll have to help me out a bit. Consider providing a link using dropbox, 1 Drive, etc. to a worksheet with realistic data.