Naming cells by numbers

Question

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 range of cells by the Item Number. I have tried to do this but it returns an error - is it possible to name a range of cells by a number or am I doing something else wrong?

lorenzo kim · Answer

pls see attached sample.hope you can make something out of it.thanks..&nbsp;

mike park · Answer

Thanks very much for your help. There are loads of item rates for each series - how would I apply yur method to this?

lorenzo kim · Answer

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..

mike park · Answer

Hi, I have attached the template application I was working on.I have removed sensitive info and replaced schedule&nbsp;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 &amp; Qty Ordered for that series also as a drop-down.I haven't&nbsp;included all the series and items as there are loads!Any help you can give would be greatly appreciated.

lorenzo kim · Answer

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..

Forum Discussion

Naming cells by numbers

10 Replies

Resources