Hi,
My intention is to update one workbook, based on another workbook. Both workbooks contain a row with names, cities and phonenumbers. Workbook 1 is build with workbook 2. So, for a name, a city and a phonenumber to appear in workbook 1, value for city = 'New York'. This is the logical reasoning I want to use:
if city name = 'New York' is
* TRUE, then:
-if name in workbook 2 = name in workbook 1 is
°TRUE: then mark the name in workbook 2 as "DONE";
°is FALSE: then add the name + city + phone number in the first empty row in workbook 1
* FALSE then: nothing has to happen
I can use the logical tests over different sheets and workbooks, but I cannot display values from an array in workbook 2 in an array in workbook 1.
The idea is to build a list of names and phonenumbers in another workbook (the main list), based on location. This workbook will have to be updated frequently and should not contain copies of names. Also, if in the main list the name is 'DONE' then the logical test of 'city' and 'name' can be skipped (which I think can speed up the process as you skip 2 logical tests).
I've been trying for half a day, but I kind of got lost...
My intention is to update one workbook, based on another workbook. Both workbooks contain a row with names, cities and phonenumbers. Workbook 1 is build with workbook 2. So, for a name, a city and a phonenumber to appear in workbook 1, value for city = 'New York'. This is the logical reasoning I want to use:
if city name = 'New York' is
* TRUE, then:
-if name in workbook 2 = name in workbook 1 is
°TRUE: then mark the name in workbook 2 as "DONE";
°is FALSE: then add the name + city + phone number in the first empty row in workbook 1
* FALSE then: nothing has to happen
I can use the logical tests over different sheets and workbooks, but I cannot display values from an array in workbook 2 in an array in workbook 1.
The idea is to build a list of names and phonenumbers in another workbook (the main list), based on location. This workbook will have to be updated frequently and should not contain copies of names. Also, if in the main list the name is 'DONE' then the logical test of 'city' and 'name' can be skipped (which I think can speed up the process as you skip 2 logical tests).
I've been trying for half a day, but I kind of got lost...
