Hi all

I have been scouring the internet for an answer to my query but nothing quite fits the bill. I will try and explain as well as I can.

We have various products to offer for arguments sake they are

£10K
£15K
£25K
£40K
£75K
£300K

If the user enters, £30,000 in cell B6, I would like the dropdown box to just offer:-

£40K
£75K
£300K

The user selects the particluar product they have sold from the options available

If they were to enter 9,800 it would show all the options etc etc, I am sure you can see where I am goign with this.

I would also like a cell link based on the particular product they select

To be honest I am not sure if this is VBA or not, so any help or guidance would really be appreciated

Thanks