View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Camron Camron is offline
external usenet poster
 
Posts: 1
Default Export to text file based on cell information

is it possible to export row information into a file that is named
based on cell information. for example

A1= BOB B1=5551234567 C1=CompanyA
A2= MIKE B2=5553456789 C2=CompanyB

export produces CompanyA.txt with the following info in it
Name BOB
Phone Number 5551234567
Company CompanyA

export also produces CompanyB.txt with the following info in it
Name MIKE
Phone Number 5553456789
Company CompanyB