I am trying to Autofill cells from a drop down menu. I want to be able to choose a "type of testing" from the drop down menu and autofill the cells with the tests that needs to be performed. I am wanting to put an "X" in the cell if the test needs to be performed. If the test is not required, leave the cell blank.
Sample Tracker.xlsx
Last edited by jamorgan29; 01-10-2012 at 09:44 PM.
Try this in E2 and drag to the right...
=INDEX($P$2:$W$5,MATCH($D2,$O$2:$O$5,0),MATCH(E$1,$P$1:$W$1,0))
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
I tried it in E2, but the X's does not change when I choose a different "type of testing". Then, what about copying it down the spreadsheet as we plug samples into the sheet.
Look at this example...
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
It would work, I am trying to show what testing needs to be performed. Whatever I need to to to make the required tests to stand out. I once thought about making the required test boxes green and the not required red. I also need help to get the boxes changing when the "type of testing" is changed.
Thank you for all of the help. I am an EXCEL novice. I enjoy trying to figure out how to use Excel to simplify my life and work-life. I'm just on a deadline with the "sample tracker"
Note sure what you are asking here? It seems like your idea with the Icon sets is good.Originally Posted by jamorgan29
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
I apologize. When the "Type of Testing" is changed from the drop down menu, the "X" under composition, moisture, vod, etc.... will either appear or not. This is just a trial sheet to present to my boss. If I could get it to work, we would type in the mix number, shop order, then select what type of testing needs to be performed from the drop down menu, the "X's" would then appear in the cells under the desired test, composition, moisture, vod, etc....
Right now if I select "Type of Testing" equals Military PBX, all cells E:L have an "X".
If I select "Type of Testing" equals Cast Cure then only Compisition and Moisture have an "X".
If I select "Type of Testing" equals Commercial PBX then Taggant, VOD, and Density have an "X".
Can you give me a specific example of how this is not working are what you required different than the above?
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
It is not working on the sheet that you uploaded above on my computer. When I change the drop down menu, nothing changes.
I'm sorry again, It works when I saved it to my computer. Thank you
You're welcome...Glad you got it working
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks