Forum Discussion
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...
in sheet("SoRs") - the series number are all 500?
if that is the case, you don't have to look there - you must look at "Item".
likewise - what is the range of qty ordered you want under G1 - is it 0-5 > 5 .....
I made some revision on the sample - pls see the notations.
thanks..
it will be much clearer if you indicate on the worksheet - what you want the result to be...
thanks..
thanks..
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.
pls see the latest revision.
hope you can make something out of it.
thanks..
pls see attached revised samples
thanks..
