How to record a macro dropdown that will auto-fill cells.

I'm assuming that is a possiblity!

In the submitted workbook, I would like the "plan" column on the Registration sheet to autofill the "Cost" columns and appropriate play and hotel selections (from the Plan Code sheet). Additionally, I would like the "plan" column to limit selections (dropdown) to the Plan Codes on sheet 2.

For example, if I select plan B2- the "Cost" column would autofill with "$600" and "1" would appear under "YoG", "12th", "TofA", "GrtE", as well as "Fri." and "Sat." hotel.

I'm relatively new to writing macros and don't have the lingo down.

Thanks, in advance, for your help!

Works fabulously, thank you xladept! I'm copying your VBA so I have it for my future reference!