LinkBack URL
About LinkBacks
@svayl
You get better help if you post an Excel-example of your workbook, without confidential information.
@svayl
You get better help if you post an Excel-example of your workbook, without confidential information.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Practice.xlsx
Ok I attached the file. Basically want to type in a code for a student and have the output be the subject. I tried doing what you told me to do, but it keeps telling me there is an error and also won't let me save the file.
Ah!
Hello, column B on sheet Jan 2012 I added code menu selection, and column C shows the subject automatically.
I do not know if that was what you asked
greetings
Practice(1).zip
Yea that is what I want. How exactly did you do that? Also, do I need to do this manually for each month(sheet)?
Then, it is not difficult, located on B2, and from the menu Data -> validation data, then choose to allow: list then from Origin: =codes!A2:A20. Ok.
For the other months, copy cell B2 and paste from the Jan2012 sheet in the sheet Feb2012, then drag down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks