Create Excel Macro (Urgent 2 Hr turnaround)

Macro instructions


Import the Following to destination file from source file:


recipient name > recipient contact name

company > recipient business name 

address 1 > recipient address line 1

address 2 > recipient address line 2

city > recipient postcode

zip code > recipient postcode

telephone > recipient phone number

State > recipient state

Box to the right of “internal Use Only” > sender reference 1
Continue to the end of the tab and then do the same for each tab on file.


On destination file add the following 


Each row add “S” to column “Row Type” for each filled in row