copy between workbook

[max_max]

Hello to all,
this macro copy value between workbook:

Please Login or Register  to view this content.

In cerca_find_new_3_prova_19_06 there is a data validation in C9
in D9-E36 data are entered that the macro find here:
Increase = Sh1.Range("C15").Value

Please Login or Register  to view this content.

every time to update the data, click on the button "copia"
it is possible that changing in data validation
do the values in D9-E9 update immediately?
I attach the two files.
The two files must be open.
I hope I explained myself
max_max

[yujin]

Why don't you use INDEX function instead of using macro?

Please Login or Register  to view this content.

[max_max]

hello I do not know index function