Display list depending whether cell is blank or not

Only if length of characters of the list is less than 255 then.
Assuming the header in row1, data starts from row2.

To a worksheet code module

Please Login or Register  to view this content.

Hi jindon, thanks for the answer!!. It does work, however the header is in row 6, data row 7 and goes from column "E" to "BA". I've tried changing the code but doesn´t seem to work. Could you check any mistakes please??

Please Login or Register  to view this content.

Also, some headers are combined cells (row 5 & 6) but not sure if that might be part of the error or not.

Originally Posted by gonurvia

Hi jindon, thanks for the answer!!. It does work, however the header is in row 6, data row 7 and goes from column "E" to "BA". I've tried changing the code but doesn´t seem to work. Could you check any mistakes please??

As I have said 255 characters, so it is not possible without hidden sheet.
Try change to

Please Login or Register  to view this content.

Originally Posted by gonurvia

Also, some headers are combined cells (row 5 & 6) but not sure if that might be part of the error or not.

What do you mean?

Captura.PNG

This is what it looks like. I've replaced the code into "Analisis" sheet code but doesn't seem to work, am I doing it right?. Im kind of new to VBA and not very good at programming either so sorry for asking so dumb questions

Thank you very much for your time jindon, I did as you said but no changes appear...

Then you need to upload your workbook.

Sadly I can't, as the workbook has sensible information.
Maybe its easier if I make a function out of 2 vectors
Something like this;

Please Login or Register  to view this content.

So, anytime there is a number over 0, it adds the cell text to the list, for all the cells in my range.
P2 would be a vector with the country names
P2 (D6:BA6)
P1 (D7:BA7)

I don't know why it doesn't work for me yet. The one you attached did work, but as soon as I changed the start columns it didn't work.

Where (which column) do you want the validation list?

Column D please

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

It still seems not to work

Working...............

Yep, it does work but for some strange reason when I paste it on my workbook it crashes... Anyways, you haven't stopped helping me so thank you very very much!!

Hi jindon, finally I've found the reason of why wasn't it working for me. I've attached a file where you may see it. Apparently, Excel only saves the last 500 values of the whole list hence, if I have 1000 rows, it will "show" a list with the first 500 values as blank and show the next 500 values correctly. You may look at it here: