Hi
I'm struggling to create a macro that will check each cell in Columns B and E and do the following:
if cell in column B = London or Washington or Paris or Brussels (there are dozens of cities but I won't list them all)!
and if cell in column E is blank then insert "text" into column E (effectively overwriting the blank 'value')
else leave the value in column E as it is
Any help greatly appreciated.
Thanks
Matt
I'm struggling to create a macro that will check each cell in Columns B and E and do the following:
if cell in column B = London or Washington or Paris or Brussels (there are dozens of cities but I won't list them all)!
and if cell in column E is blank then insert "text" into column E (effectively overwriting the blank 'value')
else leave the value in column E as it is
Any help greatly appreciated.
Thanks
Matt