donlincolnmre2
Board Regular
- Joined
- Dec 23, 2006
- Messages
- 142
Hello
I’m looking for a macro to copy records and phone number. The row without phone numbers (referring to COLUMN J) have lots more columns and lot more data I need a macro to transfer or copy the phone number from rows below into to the row above (master record) in case there are multiple child records, and only 1 master record, the macro should insert a row and copy the master row into it.
I suppose the macro should check the numeric and just first alphabetic portion of the address to find the match (e.g. 11213 FOSTER ) since some address have apts and that would throw the macro off.
Then the macro would count how many times the record appeared below and then create the master record and then copy the child records phone number into them.
This is a real challenging one, any help would be greatly appreciated.
If all else failed and it can’t be done then the macro should just copy the very first child record phone number into the master record.
COLUMN F= ADDRESS
G=CITY
H=STATE
I=ZIP
J=PHONE NUMBERS
Below is the DUMMY DATA.
F G H I j
1121 LOTEBUSH LN BARSTOW CA 91601 3679-H5
11213 FOSTER RD NORWALK, CA 91601 736-F2
11213 FOSTER RD NORWALK, CA 91601 5624091827
11213 FOSTER RD NORWALK, CA 91601 5628638970
11215 HATTERAS ST NORTH HOLLYWOOD CA 91601 562-J1
11215 HATTERAS ST N HOLLYWOOD, CA 91601 8185087796
11215 HATTERAS ST NORTH HOLLYWOOD, CA 91601 8186237910
11216 DEBRA AVE SAN FERNANDO CA 91344
11216 S FIGUEROA LOS ANGELES, CA 9134 704-B6
11216 S FIGUEROA ST LOS ANGELES, CA 9134 3232421161
11216 S FIGUEROA ST, APT 2 LOS ANGELES, CA 9134 3234189687
11216 S FIGUEROA ST, APT 3 LOS ANGELES, CA 9134 3237561280
11216 S FIGUEROA ST, APT 7 LOS ANGELES, CA 9134 3237579304
11216 S FIGUEROA ST, APT 8 LOS ANGELES, CA 9134 3237799190
11226 FORBES AVE GRANADA HILLS CA 91344 501-D1
11248 TERRA VISTA PKWY 83 RANCHO CUCAMONGA CA 91730 573-D7
I’m looking for a macro to copy records and phone number. The row without phone numbers (referring to COLUMN J) have lots more columns and lot more data I need a macro to transfer or copy the phone number from rows below into to the row above (master record) in case there are multiple child records, and only 1 master record, the macro should insert a row and copy the master row into it.
I suppose the macro should check the numeric and just first alphabetic portion of the address to find the match (e.g. 11213 FOSTER ) since some address have apts and that would throw the macro off.
Then the macro would count how many times the record appeared below and then create the master record and then copy the child records phone number into them.
This is a real challenging one, any help would be greatly appreciated.
If all else failed and it can’t be done then the macro should just copy the very first child record phone number into the master record.
COLUMN F= ADDRESS
G=CITY
H=STATE
I=ZIP
J=PHONE NUMBERS
Below is the DUMMY DATA.
F G H I j
1121 LOTEBUSH LN BARSTOW CA 91601 3679-H5
11213 FOSTER RD NORWALK, CA 91601 736-F2
11213 FOSTER RD NORWALK, CA 91601 5624091827
11213 FOSTER RD NORWALK, CA 91601 5628638970
11215 HATTERAS ST NORTH HOLLYWOOD CA 91601 562-J1
11215 HATTERAS ST N HOLLYWOOD, CA 91601 8185087796
11215 HATTERAS ST NORTH HOLLYWOOD, CA 91601 8186237910
11216 DEBRA AVE SAN FERNANDO CA 91344
11216 S FIGUEROA LOS ANGELES, CA 9134 704-B6
11216 S FIGUEROA ST LOS ANGELES, CA 9134 3232421161
11216 S FIGUEROA ST, APT 2 LOS ANGELES, CA 9134 3234189687
11216 S FIGUEROA ST, APT 3 LOS ANGELES, CA 9134 3237561280
11216 S FIGUEROA ST, APT 7 LOS ANGELES, CA 9134 3237579304
11216 S FIGUEROA ST, APT 8 LOS ANGELES, CA 9134 3237799190
11226 FORBES AVE GRANADA HILLS CA 91344 501-D1
11248 TERRA VISTA PKWY 83 RANCHO CUCAMONGA CA 91730 573-D7
