Best way to place text data into a formated Template?

L

Lon

I am trying to format a text file (raw data) that contains sales info into an
Excel (2003) Packing Slip Template. Do I use a macro to do this, or can I use
the import feature? What ever I use, I need to delineate when a new packing
slip should be generated, based on a new order-id. Thank you in advance for
any help I can get.
 
A

Arceedee

Without having the full facts it's impossible to know what to suggest.
You could format your text file (Word?) prior to import or you could import
into an Excel file then use 'Text to columns' feature to format as your
template and then copy into the template.
I can't answer the new packing slip generation part of the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generated text copies into another template 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Creating a Search using a combo box and then creating a report. 4
Template bullet style changes when applied to existing document 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Linking data in MS Word into Excel 5
hiding the Data used for my drop downlist 1
data from multiple files: best way to extract 1

Top