ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro help (https://www.excelbanter.com/excel-programming/363291-macro-help.html)

phil2006[_2_]

Macro help
 

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



All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com