problem with Formating the DataValidation List

Hello guys,
I am doing a project and i need to pull the values from the excel sheet, just for maintainability i need to make some modifications to the
existing data, and am unable to attain what i wanted.

Three things i have
1. package name
2. Tc.Name
3. Ie,MOZ,SAF
Hirearchy is from 1 to 3. Am using the data validation list to set it manually what i wanted. But i need some tweaks to it. I have attached the sample excelsheet along with this thread.

If i enable the package name it should automatically display all the Tc names as enabled and other three columns as YES
If i disable it all tc names should be set as disabled and other three colums as NO
If i set as partial it should allow me to set the other three columns manually and it should also allow me to set the tc names mode also.

One more thing is
here package 1 starts with A3 package 2 with A 11 and package 3 with 19

P1 is enabled so it displayes all tc names until C9
P2 is disabled so it shouldnot display anything till C17
P3 is partial so i can display till c 25.

I am not sure how tough it is in making but i would love to do that, i browsing through this forum and i thought i could get some help. plz share ur thoughts.
Thanks in advance

hi Appunu,

Welcome to the Forum

Can you please change your thread title?

Rules 1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

Rob

This macro placed into the sheet1 code module will do what you've asked.

Please Login or Register  to view this content.

Just make your choices in column B and the other cells will format.

Please Login or Register  to view this content.

Unless you lock the sheet, the cells are editable. Other than that I don't know what you mean.

The code I gave you works off of cell addresses. You can put your data into a table and adjust the macro to the new addresses.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.


========

Note: In each of your followup posts above you QUOTED my entire post, for no purpose at all. Do not use the QUOTE feature superflously. Use the QUICK REPLY box down below. Cheers.