shir0206
04-03-2019, 05:51 AM
Hello,
Please advise –I receive the following input (column “INPUT (#1)” in the print screen), and I would like to create a VBA code that creates a list out of it, as described in the output (column “OUTPUT” in the print screen).
So far I I wrote a code that uses “text to columns” and changes “INPUT (#1)” into “INPUT (#2)”.
However, I have no idea how to get to the required “OUTPUT”.
23996
Could anyone help me please?
Thank you very much!
Please advise –I receive the following input (column “INPUT (#1)” in the print screen), and I would like to create a VBA code that creates a list out of it, as described in the output (column “OUTPUT” in the print screen).
So far I I wrote a code that uses “text to columns” and changes “INPUT (#1)” into “INPUT (#2)”.
However, I have no idea how to get to the required “OUTPUT”.
23996
Could anyone help me please?
Thank you very much!