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.


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=548519