Forum Discussion

Mike Park's avatar
Mike Park
Copper Contributor
Oct 13, 2018

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...
excel
Mike Park's avatar
Mike Park
Copper Contributor
Oct 13, 2018

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's avatar
Lorenzo Kim
Bronze Contributor
Oct 13, 2018
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's avatar
    Mike Park
    Copper Contributor
    Oct 13, 2018

    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.

Resources