A
andreashermle
Dear Experts:
I got a name list on a worksheet with the following columns
SURNAME NAME CITY
Smith John New York City
Wilber Joe Denver
Garden Thomas San Diego
This list has for example twenty rows / data records. For certain
reasons the following action should be excecuted automatically (using
VBA) on my list regardless of the number of rows:
Duplicate each row and place it directly under the one copied. The
result would then look like this:
SURNAME NAME CITY
Smith John New York City
Smith John New York City
Wilber Joe Denver
Wilber Joe Denver
Garden Thomas San Diego
Garden Thomas San Diego
Help is much appreciated.
Thank you very much in advance. Regards, Andreas
I got a name list on a worksheet with the following columns
SURNAME NAME CITY
Smith John New York City
Wilber Joe Denver
Garden Thomas San Diego
This list has for example twenty rows / data records. For certain
reasons the following action should be excecuted automatically (using
VBA) on my list regardless of the number of rows:
Duplicate each row and place it directly under the one copied. The
result would then look like this:
SURNAME NAME CITY
Smith John New York City
Smith John New York City
Wilber Joe Denver
Wilber Joe Denver
Garden Thomas San Diego
Garden Thomas San Diego
Help is much appreciated.
Thank you very much in advance. Regards, Andreas