Data validation

[tofimoon4]

Dear sir,with best regards,asking you kindly to help me about the question mentioned in attached file.
Thanks in advance.

[tofimoon4]

Dear sir, sorry for mistake, please consider ( data validation ) in the attached file as (drop down list).
sorry again.

[tofimoon4]

Dear sir,i am still waiting your honor.
Sorry for insistence.

[VBA Noob]

I use a helper column (Col P) with the formula

=IF(ISERROR(SMALL($C$13:$C$40,ROW(A1))),"",SMALL($C$13:$C$40,ROW(A1)))

Then use a dynamic name ranged as below
http://www.contextures.com/xlNames01.html#Dynamic

=OFFSET(ورقة1!$P$14,0,0,COUNTIF(ورقة1!$P:$P,">0"),1)

HTH

VBA Noob

[tofimoon4]

Dear sir,many thanks for your reply, because i am newuser and dont know ( how and where i put these formulas) asking you kindly to applicate them on my example or directing me to the using way ,please.

[VBA Noob]

Sorry,

Thought I had uploaded the example

Here it is

VBA Noob

[tofimoon4]

Dear sir, sorry for the disturbance,but when i press any invoice nos. from the drop down list i got nothing,i mean i didnot obtain any change.
I hope you shall help me again.
Thanks in advance.

[VBA Noob]

i mean i didnot obtain any change

What change are you after?

VBA Noob

[tofimoon4]

Dear sir,it seems to me that my need wasnot clear enough to reach the goal , i think i took more from your time for this matter, my need was ( how to jump to the invoices details by clicking on their nos. from the drop down list ) or ( how to sort the invoices details by their nos.) for about ( 500 ) invoices.
Many thanks for your help.

[VBA Noob]

Right click the sheet tab > select view code and paste in the below. Works when you change Cell L14

Please Login or Register  to view this content.

VBA Noob

[tofimoon4]

Dear sir, you are genius ,it works very well.
Thank you very much.

[VBA Noob]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[tofimoon4]

dear sir,with my apologize,if i want to copy this code to another work book, what can i change exept ( l14)?

[VBA Noob]

what can i change exept ( l14)?

Not sure I follow. If you place the code in another sheet on another workbook and the data validation list is in a different cell then yes change the cell reference

VBA Noob