Copying selected data from a workbook to newly created workbooks

Closed
Report
-
Hello,
I am trying to automate a process of identifying phone calls from a master file containing 200 phone numbers. I need to create files per each phone number and send them to staff members for their personal phone call identification. For this purpose, I need an assistance in creating a macro, where it will:
  • open the master data file
  • select the data based on the phone number in column "A"
  • Copy all the rows pertaining to a given phone number
  • Open the template and paste the selected rows
  • Close the file and save it with a "phone number" as the file name
  • Do the same for the next phone number and so on

Your kind assistance is highly appreciated . I am very new at writing Macros and this task is not manageable on my own.
Thanks in advance ,
Ed