I am in need of assistance with creating a VBA script to pull info from a delimited text file and create multiple new spreadsheets.
What I have is a spreadsheet that is used for submitting vender disbursements. I need to take the existing form, fill in various cells with vender info from a delimited text file and then save each vender to a new spreadsheet as a "template".
Here is the details for they want:
Headers from ~ (tilde) delimited text file:
~NAME~ADDRESS~CITY~STATE~ZIP~ROUTING NUMBER~BANK NAME~ACCOUNT NUMBER
Help, way in over my head here.
What I have is a spreadsheet that is used for submitting vender disbursements. I need to take the existing form, fill in various cells with vender info from a delimited text file and then save each vender to a new spreadsheet as a "template".
Here is the details for they want:
- Vendor Name – cell B9
- Vendor Address – cells B11, B12, B13 and B14
- Receiving Bank ABA Number – cell B17
- Receiving Bank Name – cell D17
- Receiving Bank Account Number – cell B19
- If possible, alter the text in cell F1 to reflect “CHECK (X) WIRE ( ) ACH ( )” when no banking information is present and “CHECK ( ) WIRE ( ) ACH (X)” when banking information is present
Headers from ~ (tilde) delimited text file:
~NAME~ADDRESS~CITY~STATE~ZIP~ROUTING NUMBER~BANK NAME~ACCOUNT NUMBER
Help, way in over my head here.