What function would I need to use to update from my second sheet to my first using macros? I am creating a sheet based on countries so when the Ukraine, for example, is the country in question I need to add their corresponding value and when the country is Canada I need to add theirs etc. I have been attempting using the 'if' function but this does not work and doesn't include enough potential country names. Ideally I need a function that shall allow me to add each countries' individual corresponding value.
Thanks for your help.