Validating a cell value excel macro


The data for their number of absences is stored in Names worksheet. Im new with VMB and I've been working on this for 2 weeks now. The worksheets look as follows: "Names" worksheet: Name Absences Late student1 1 3 student2 1 0 student3 3 1 "Summary" worksheet: Name Absences student1 1 student2 1 student3 3 Hi I have created few views: i have columns like Nov-07, Dec-07, Jan-08, Feb-08 till Dec15 First view is just showing months in year 2007 and the name of the view is 2007 and another view named 2008, which is showing all the months in 2008 and hiding the remaining, now I want if the user put 2007 in a particular cel than the view 2007 get activated and so on like if 2009 ten it should activate the view named 2009, pls help and I have many sheets whic has the same format and want the same views for all the sheets and same functionality. Sands B Hi, I encounter the same problem today but, as I wanted to download the file Wut Up posted with the explanation I could not. End If when you say "what about if you want to set it to a specific value, not just to change". This event is triggered if a value of a cell is changed manually.I cant just copy paste because I want this macro to run in "Summary" worksheet everytime a new data is enetered in "Names" sheet. Many thanks in advance if possible or not I tried this but nothing happens. Would you kindly send me that file regardind your first doubt ? Hi May be this will helpfull to you, try below one Private Sub Worksheet_Change(By Val Target As Range) Set My Plage = Range("G4: M11") For Each Cell In My Plage If Cell. Hi, Thank you for this thread, It has been a great help to me. I have a spreadsheet which calls on data from SQL which my I.Since you are using Excel 2007, this is what you do. 4) Now, at the top of the code window you will see...

validating a cell value excel macro-22

Because of this thread I do sort of know what you mean but the code doesnt seem to be working for me.

Private Sub Worksheet_Change(By Val Target As Range) If Target. I need help using creating a macro that finds corresponding/matching values. In Summary worksheet, I have the column A with the names of my students. I need to get their corresponding number of absences.

Excel's Data Validation function can eliminate the confusion.

The travel department of a major company asked its travel agents to track flights using dates, route codes (e.g., DEN-LAX-DEN) and destination city.

You do not want that, you want to enter a value in D10. Private Sub Worksheet_Change(By Val Target As Range) 8) Now this is where you want the code...