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

pls see attached sample.

hope you can make something out of it.

thanks..

 

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