PDA

View Full Version : Fill down name according to column B



Pamella
08-25-2019, 08:15 PM
In Column B I have names with Id's underneath. I need to add the names in Column A, via macro.


COL B
"Smith"
TH123
12334
REBBB
56322
43433
"Jeffs"
65433
223344
212311
123
"Randal"
W2123
TRSDS


Col A Col B
Smith
Smith TH123
Smith 12334
Smith REBB
Smith 56322
Smith 43433
Jeffs
Jeffs 65433
Jeffs 223344
Jeffs 212311
Jeffs 123
Randal
Randal W2123
Randal TRSDS

p45cal
08-26-2019, 12:20 AM
Please supply a workbook with the above in. It's unclear whether the starting data has qute marks in. A workbook will answer a number of other questions which otherwise we'd have to guess at (probably wrongly).
(I foresee a difficulty with the last entry TRSDS and identifying whether it's a person's name or an ID)