VBA based on only one drop down menu option in multiple columns

[Webbers]

Okay, first thanks for all your help, it is greatly appreciated.

I have a need for a VBA script, perhaps a workbook change event. I have a large spreadsheet (approx 300+ columns) and I have a named range called "Plans" that is used for data validation in 6-12 different columns (multiple spreadsheets that are somewhat similar). Anyways these cells use a dynamic drop-down so only the relevant options are listed based on what is selected. Is it possible (I hope!) that if "None" is selected from any of the columns using "Plans" as the data validation list that specific cells within the cell within that same row would auto populate with specific data? The data to auto populate for None will remain constant.

For example the first instance in this particular version of the spreadsheet is Column AM that contains the named range "Plans". Now if none is not selected the user will simply select the proper option from each drop down, but if None is selected (from Column AM for example), then the following would auto populate:

Column AN: None
Column AO: None
Column AP: N/A

Columns AS - AV: skip these cells

Column AW: 0
Column AX: 0
Column AY: 0
Column AZ: 0

Now, on this particular spreadsheet, "Plans" is the named range for data validation in multiple columns as I mentioned: AM, BC, BS, CI, CY, DO, EE, EU. The format for each of these sections is identical. Since if None is not the option chose the user must select the proper dropdown options and then enter dollar amounts for the final 4 cells within the row, so I cannot use formulas for this.

Is this even possible? Thanks again!

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Webbers]

Dave----
Just wanted to confirm I saw you message and I will create the before & after sample files you requested.

[Webbers]

Now as I was creating this sample file, I realized a single file (rather than a "before and after" would be sufficient... at least the way I see this. I have trimmed most of the excess of this file so we can focus on the "task".

I have completed Sections A1 (Columns H - K & R - U) based on the fact this this section did not apply, and the None, N/A, and 0's were entered. FYI... the gray cells (Columns N - Q) would normally be formulas, but I converted to values for this example so I could delete that large tab form this example. Now a similar section, section A2, begins in Column V-Y and AF-AI. If the user selects None in Column V (remember I would like this based on the named range of "Plans" rather than the columns if possible) then the next 2 corresponding cells (Columns W & X in this example) would be filled with "None" and Column Y with "N/A", and Columns AF - AI with the number 0. Like I initially mentioned, there are between 6-12 of these sections.

In addition, I don't know if it matters, however I feel it is worth mentioning:
This spreadsheet contains ONLY this one row for data entry, row 4... I have a macro that loops through the folders and copies all data to a master file.