Hi All,
I don't know to write VBA, but I have adopted and edited syntax in the past. But I can't figure out how to do this.
I inherited a file at work with few thousands of lines. The ID# is in column A - Col B has multiple lines of data (Dates) in a single cell(Created Alt+Enter) for that same location. I would like split out the dates - add a new lines for each date in column B, while retain the ID Loc # for these dates in column A. Can someone please help me with this, if it's Possible to achieve in VBA? Please see sample file for your reference.
Thank you
Imran
I don't know to write VBA, but I have adopted and edited syntax in the past. But I can't figure out how to do this.
I inherited a file at work with few thousands of lines. The ID# is in column A - Col B has multiple lines of data (Dates) in a single cell(Created Alt+Enter) for that same location. I would like split out the dates - add a new lines for each date in column B, while retain the ID Loc # for these dates in column A. Can someone please help me with this, if it's Possible to achieve in VBA? Please see sample file for your reference.
Thank you
Imran