Lookup a table and then do this
Posted on 2015-02-05
In a sheet named Static I have a table with Country names in column A.
Please provide me with VBA code that will look up this table and if a Sheet with the name[s] in column A exists, Call my macro [named CreateAgeBands] for each one of the countries.
so: look up Static column A [lets say A2 = Spain] if a sheet exists for Spain call my macro [CreateAgeBands] then move on to A3 in static etc etc