D
dfkelly42
I have text in a spreadsheet, not wrapped text but single line per row.
I wish to create a macro that will copy and paste th
address/state/zip/phone info into seperate cols to the right of th
name.
I have created a macro that will only paste to Row #1.
HOW.... do I designate the selected box(ie name #2 or cell #A2) to b
the starting point for the macro as I work down the page.
(Current)
Bob Smith
1234 turkey Ave
Putsville, UT
12345
(999)999-9999
Bill Smith
1235 Hen peck road
butte, Mt
65432
(999) 555-5555
(Wanted in 5 cols)
Bob Smith/1234 turkey ave/putsville, UT/12345/(999)999-9999
Bill Smith/1235 Henpeck Rd/etc...........get the idea?
The macro will cut and paste in different cells on the same row bu
repeats itself to the original row when I procede down the page.
I built a macro but it is tied to the original cell number.
How do I lose the cell number distinction so I can work my way down th
document. I have 300 of these....
PLEASE HELP,
Do
I wish to create a macro that will copy and paste th
address/state/zip/phone info into seperate cols to the right of th
name.
I have created a macro that will only paste to Row #1.
HOW.... do I designate the selected box(ie name #2 or cell #A2) to b
the starting point for the macro as I work down the page.
(Current)
Bob Smith
1234 turkey Ave
Putsville, UT
12345
(999)999-9999
Bill Smith
1235 Hen peck road
butte, Mt
65432
(999) 555-5555
(Wanted in 5 cols)
Bob Smith/1234 turkey ave/putsville, UT/12345/(999)999-9999
Bill Smith/1235 Henpeck Rd/etc...........get the idea?
The macro will cut and paste in different cells on the same row bu
repeats itself to the original row when I procede down the page.
I built a macro but it is tied to the original cell number.
How do I lose the cell number distinction so I can work my way down th
document. I have 300 of these....
PLEASE HELP,
Do