don lincoln
New Member
Hello
I’m looking for a macro
I have a spread sheet with column A through K
Column I, J, K contains phone numbers
Column I is the one which has most of the phone numbers. I’m looking for a macro that will look at column I each cell by cell and if it finds a blank cell then it should go to COLUMN J in that row to see if it contains any data, if it does then it should copy that over to COLUMN I.
And if in COLUMN J if that row is BLANK then it should look for data in COLUMN K and if it finds it then copy that cell’s data to COLUMN I
e.g Row 3 contains number ending 0091 in COLUMN J and COLUMN I is empty in that row so the macro should copy the phone number 760-475-0091 to COLUMN I in row 3
another example the 4th row from the bottom is all blank except its got 866 number in COLUMN K, so the macro should copy that number back to COLUMN I in that row.
Any help would be greatly appreciated.
Thanks.
BELOW IS THE DUMMY DATA.
COLUMN I COLUMN J COLUMN K
I’m looking for a macro
I have a spread sheet with column A through K
Column I, J, K contains phone numbers
Column I is the one which has most of the phone numbers. I’m looking for a macro that will look at column I each cell by cell and if it finds a blank cell then it should go to COLUMN J in that row to see if it contains any data, if it does then it should copy that over to COLUMN I.
And if in COLUMN J if that row is BLANK then it should look for data in COLUMN K and if it finds it then copy that cell’s data to COLUMN I
e.g Row 3 contains number ending 0091 in COLUMN J and COLUMN I is empty in that row so the macro should copy the phone number 760-475-0091 to COLUMN I in row 3
another example the 4th row from the bottom is all blank except its got 866 number in COLUMN K, so the macro should copy that number back to COLUMN I in that row.
Any help would be greatly appreciated.
Thanks.
BELOW IS THE DUMMY DATA.
COLUMN I COLUMN J COLUMN K
MobilePhone | HomePhone | OfficePhone |
7609634614 | 760-244-5461 | |
760-475-0091 | 760-475-0091 | |
6269451121 | 626-945-1121 | 760-407-6441 |
6269451121 | 626-945-1121 | 760-407-6441 |
760-662-9411 | 760-249-5001 | |
619-729-7231 | 619-584-9421 | |
6269451121 | 626-945-1121 | 760-407-6441 |
619-313-3201 | 619-333-8081 | 619-333-8081 |
6269451121 | 626-945-1121 | 760-407-6441 |
866-344-7471 | ||
760-900-0031 | 760-245-7321 | |
951-454-4851 | 951-729-3341 | |
714-483-1331 | 951-304-2121 |