ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Export to text file based on cell information (https://www.excelbanter.com/excel-discussion-misc-queries/237905-export-text-file-based-cell-information.html)

Camron

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




All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com