Forum Discussion
Mike Park
Oct 12, 2018Copper Contributor
Naming cells by numbers
I am trying to build an application for payment in excel. There are Series numbers that each have Item numbers. I want to use nested dropdown lists but from what I can see this would mean naming a ra...
Lorenzo Kim
Oct 13, 2018Bronze Contributor
kindly attach a non-sensitive sample -- so people here can have a better view of your query.
there are many good people here that can help you.
thanks..
there are many good people here that can help you.
thanks..
Mike Park
Oct 13, 2018Copper Contributor
Hi, I have attached the template application I was working on.
I have removed sensitive info and replaced schedule of rates with made up ones.
If you look at the Cyclical Gullies tab you will see I want to select the Series Number from a drop-down which will, in turn, offer me the relevant Item Numbers & Qty Ordered for that series also as a drop-down.
I haven't included all the series and items as there are loads!
Any help you can give would be greatly appreciated.