Forum Discussion
Mike Park
Oct 13, 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
it will be much clearer if you indicate on the worksheet - what you want the result to be...
thanks..
thanks..
Mike Park
Oct 13, 2018Copper Contributor
There are many series numbers, each with many item numbers. I have just selected one series to demonstrate what I'm trying to do as the issue
I have attached the template again but added another series to the SoR tab & added comments to the cells in the Cyclical Gullies tabs for what I'm trying to do.
- Lorenzo KimOct 14, 2018Bronze Contributor
pls see the latest revision.
hope you can make something out of it.
thanks..
- Lorenzo KimOct 14, 2018Bronze Contributor
pls see attached revised samples
thanks..