No. I think I figured it out.
It turns out my macro didn't quite work the way I wanted. Can you revisit the question and help?
!!! Do you have another file sharing option? I keep getting an error message with wikisend.com!!!!
Ok, so in the SEP tab I have a form. I created a drop-down list in the merged cells T9:AB9 using data in column AC. I would like to be able to populate the merged cells in M16:Q16 with the list of classes found on the Data spreadsheet with the appropriate list based on what is selected on T9:AB9.
For example: if Administration of Justice is selected in the drop down then the data from column B on the Data spreadsheet will be listed in SEP spreadsheet M16:Q16, and if Admin Jus - Correctional Science is selected then the list in column C is populated, and so on.
M16:Q16 will be based on what is selected in T9:AB9
Too costly, PC-guy. :-( is there any onther way for you to explain the steps?
I understand completely, and I don't fault you for the price. It's just that I am creating this spreadsheet for the job, but the cost is out-of-pocket. My pockets just happen to be much too shallow!! I really appreciate you taking the time. I will absolutely give you an excellent rating, regardless.