Hello,
I'm having a hard time trying to find a macro for the following use:
Taking in consideration the example (http://imgur.com/a/JqeQW), consider that i have in the "sheet 1" the table with the columns Country and Food.
In the sheet 2, i have two columns named Country#1 and Food#1. The macro i want, needs to autofill the Food#1 cell that is associated with the right text in Country#1 cell, via the drop down list.
Example: When i select "Madrid" in Country#1, it needs to autofill the Food#1 with the text "Tapas and tortillas".
Thank you for all the help.
Best regards,
Luís