Hi
I have a list of approx 130 suppliers that I want to use as my list for a drop down box
In my range for the drop down I make the range bigger in case I add suppliers
What I want to do is
- have a formula work out which is the last valid row
- use this cell ref in my sort and range formulas
Any tips?
Graham
I have a list of approx 130 suppliers that I want to use as my list for a drop down box
In my range for the drop down I make the range bigger in case I add suppliers
What I want to do is
- have a formula work out which is the last valid row
- use this cell ref in my sort and range formulas
Any tips?
Graham