I am trying to make a list based on choice made in other list but its not working
If I try it in another new sheet it is working fine. Anyone know what the problem could be?
error.png
I am trying to make a list based on choice made in other list but its not working
If I try it in another new sheet it is working fine. Anyone know what the problem could be?
error.png
There is not much point in attaching image files to posts in this forum, as many contributors are not able to view pictures. Attach a sample Excel file instead.
Pete
Could i just send the whole document?
I also tried it in another workbook and there it worked fine
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
It's a very small document so i attached the whole sheet log sheet can be ignored in Accounts tab is a dynamic list of added accounts of persons and objects
I am trying now to add in the actions sheet a deposit / withdraw form kind of thing and I want that you can choose where you want to transfer money from and to.
so the first list you can choose from object,person or none with object I want the object list to appear next to it, the same I want with the person option with none I want no list to appear.
huisadmin.xlsm
I can't see where you want to put the formula with INDIRECT, but I think your problem is that you have defined the named ranges Person and Object using the OFFSET function, which is volatile, and INDIRECT is also volatile so you won't be able to use them that way. However, you can change the definition of Person from:
=Accounts!$D$2:INDEX(OFFSET(Accounts!$D$2,0,0,settings!$C$18,1),settings!$C$20)
to:
=Accounts!$D$2:INDEX(Accounts!$D:$D,settings!$C$20+1)
and that will avoid using a volatile function in the name definition, so you will be able to use INDIRECT with it. Make a similar change to the definition of Object.
Hope this helps.
Pete
I wanted to make 2 dropdown lists with data validation to choice to withdraw or deposit money from or to. so in the box with the buttons with deposit and withdraw. changing the function didn't work for me I am still getting the error.
Thanks for your reply and hope to hear from you soon.
I'm not really sure what you are trying to do. Which are the cells that you want this DV to apply to? Is it E15 and E17 in the Actions sheet, controlled by the settings in C15 and C17 respectively?
Pete
sorry for my late responds
What I want is to use the dropdown list (addaccount_dropdown_entity) in C15 and C17 from the actions sheet, to select the dropdown list in E15 and E17 (person or object).
so E15 would be with data validation (list) =indirect(C15) and E17 =indirect(C17)
addaccount_dropdown_entity located in the settings list
person and object are dynamic
Marijn
Last edited by Marijn; 08-14-2015 at 04:04 AM.
It appears that you can't use INDIRECT with a dynamic named range. If you set person and object to be static ranges then the data validation that you are trying to accomplish will work.
Hope this helps.
Pete
ok well thats something for excel dev team to work on.
thanks for all your help
Glad to help - thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.
Pete
I think I can come back on this thread since there is a way to make dynamic lists by first making a table and out of that table making a list it will dynamically expand the list as new data is added. the only problem I now have that one lists expands and the other one doesn't. But I hope I'll figure this out soon.
Answer:
one list was build out of information from other cells it has to be a hardcoded value to work (not =IF(OR(C32="",B32=""),"",C32 & " , " & B32) ) which I used
Last edited by Marijn; 08-16-2015 at 08:44 AM.
If you made a pivot table out of the data, you only have to refreh the data.
Excel 2013 data => refresh
If you question is not solved any more, please unmark it.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks