Data validation fit

[graiggoriz]

Hello,

I need to use a list that would fit with the information I would enter as on goes along...

I have a Data base in sheet "2" and I would like to have from sheet "1" the drop down list in cell C2 equal to the column B:B but with no blank row! So if I have 3 row in B:B I would like to have only 3 option in the drop down menu.

Please refer the attachement and you will get me better :-D

Many Thanks,
Graig

[Tony Valko]

What version of Excel are you using?

[Fotis1991]

Use dynamic range in your validation list..

http://chandoo.org/wp/2010/09/13/dyn...idation-excel/