Forum Discussion
Excel Formula for database
May_ThuThu_Aung, it is a bit confusing but I think you will find the answer in the links that I will provide below. Please let me know if that solved your problem. If you still need help after that, please answer back sending a sample file and I'll try to help further.
video: https://www.youtube.com/watch?v=VxReJslyJm8 (see more information on the video description.)
Playlist with other examples: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y
All the best.
HI Celia_Alves
How are you?
Now I'm working on the database and I always thank you for helping me.
I'm here to need your help again. It is about the database also the same one. I was OK with the previous database that you help me before in formula creating and I'm going to start the data entry process very soon.
But, I got one more issue that in each of the districts have respective townships. I was trying to link with "Districts" and "Townships" to avoid to choose the townships from the long lists. I want to change the Townships name depends on the Districts that I chose. I was out of the idea of how to and have tried in the database. After all, I've no idea and wrote this request to you. Please kindly see my working file so far.
I was wondering if you could help me to solve this error again. Please accept my apology for bothering you again. Thank you so much.
The attached file of My Data_Version1 is completed with combine township and version2_error file is my working file so far.
Best regards,
May Thu
- Hi, May!
Thank you for your kind words. Here, all is well; I am also working from home. I hope you are well and safe too.
I hope that you can continue your database work using the file that I sent you. If you are not sure how to continue, please feel free to reach out.
Stay safe and take good care.
Celia How do you do?
Well received your reply and sorry to get back to you late because of an internet connection problem. Start from this week we are working from home to protect Covid-19 and we have prepared remote working set up until the end of this month and maybe the end of April.
I've looked at the database but not testing on my own yet. But it looks OK and accepts my apology for making you confuse with my database. Thank you so so much for your help so far, without you I can't make it by myself. You are a good contributor for me through this Microsoft Tech Community. I didn't expect that I could find someone to help me and my database. Thanks so much again.
How's everything in your country? Is everything fine? Please special take care of yourself and your family.
Have safe and healthy days with you and your family.
Yours sincerely,
May Thu 😄
Your file is getting quite complex and would probably need deeper attention than the one I can offer right now.
Similar work to the one that I made on sheet References has to be done.
RegionCodes table needs to be duplicated on a DistrictCodes table.
A table with the townships for each district needs to be created and named according to the code determined on the DistrictCodes table.
The data validation rule for the Townships column needs to lookup the district name in the new DistrictCodes table and find the corresponding table of townships for that district.
I have done some work for you.
On the table RegionCodes you can delete the column Townships Table if you don't need those Township tables by region. Instead, you need to build as many tables as districts that you have with the Townships that belong to each district. I already made one table as example for Hinthada District.
The formula in the named range "Townships" was amended.
On the All Contacts sheet, you can see that The last row is working well according to the Hinthada Townships table that I created.
Now you need to:
- complete the list of all districts
- give each one a code in column 2 of the Districts code table
- build all the different tables for each district with the corresponding townships and name them according to column 3 of the Districts code table
I moved all the tables with townships by region below. You can use them to copy the names you need for each new district list of townships and then you and delete all the black tables with townships by region.
I hope this helps. Please see file attached