blackie42
11-23-2016, 05:47 AM
Hi Guys,
Would like to have a macro that ideally does the following (or alternatively a formula).
Starting from row 2 (as row 1 has headers). So
in cells A2 to A5000 will have the string "sw"
in cells B2 to B5000 will have either "sell" or "buy"
in cells C2 to C5000 the formula (ideally some code) will look to change the "sw & sell" taken from cells A & B to switchout in cell C
or "sw buy" taken from cells A & B to switchin in cell C.
Any help will be much appreciated..
thanks
Jon
Would like to have a macro that ideally does the following (or alternatively a formula).
Starting from row 2 (as row 1 has headers). So
in cells A2 to A5000 will have the string "sw"
in cells B2 to B5000 will have either "sell" or "buy"
in cells C2 to C5000 the formula (ideally some code) will look to change the "sw & sell" taken from cells A & B to switchout in cell C
or "sw buy" taken from cells A & B to switchin in cell C.
Any help will be much appreciated..
thanks
Jon