I need help in creating a macro for the attached file.
What I'm trying to do is to build a list of keywords for every city:
In the current example (the attached file) there is a list of 81
combinations which are listed in Column-D (Cell-D2 through Cell-82). I
need the Macro to run for each city all 81 combinations (this list can change in length, so the macro should run as long as there is content).
The file includes a sample input/output that the code would need to produce.
For columns A and B - you need to take the input from Column-F (Column-C should be ignored)
For column-D you should take the input from column-G OR column-H OR
column-I. This depends on which keyword is specified in column-D:
If it says: Cell-G2 then you should take from Column-G
If it says: Cell-H2 then you should take from Column-H
If it says: Cell-I2 then you should take from Column-I
I hope the aim here is clear, it is as simple as it reads…