Hello,
I have an Excel document that is used primary to to pull data from a report. The phone number is in column C, but we are also working off alternate phone numbers in column D.
If the phone number field is blank, i'm wondering if a macro can literally pull the alternate phone number in column D to populate the phone number in column C.
Thank you for any help!