Log In
Register
Home
February 11, 2022
Offline
I am in need of some help in adding multiple data validation to a Check Book Register and Budget file I have in Excel. I have been using regular data validation, but would like to go to what was described in the 1st part of the video "Easy Dynamic Data Validation Two Ways". I am using a MacBook Pro running 12.1 and my Excel version is 16.57. The file I have attached is a portion of my complete file minus current data, and several sheets that do not pertain to my question and need for help. Feel free to edit any part of the attached file.
Thank you!
I really like your video! I have a stand alone version of just Excel(Home & Student) I just purchased from Microsoft last month. I am trying to add the dependent data validation to an existing file. It is a checkbook register and budget, and the register has about 4500 rows and I have been using regular data validation. I am a little lost on what may be the best way to incorporate your 1st method into my file. I have 12 Parent Categories plus about 100 sub-categories in 2 separate columns.
Hello again, I wrote you about 4 hours ago, and have been trying to get the dependent data validation working in my Check Register and Budget file. I am not having any success and do not know what the problem may be. I have made named ranges for all my Parent/Sub-Categories, and have made and named all as tables, including my main check register. When I try to make data validation using the names range “Names” I receive an error. Could I email you a sample of what I am doing?
July 16, 2010
Offline
Hi David,
It doesn't like the Parent list being in a Table. If you convert this to regular cells and rename it 'Parent' as you'll lose the name when you convert it, then the dependent data validation works.
Mynda
1 Guest(s)
