| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to place text data into a formated Template?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Best way to place text data into a formated Template?
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. "Lon" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to place a calendar template on my desktop. | Excel Worksheet Functions | |||
| Retrieve text from filter data in workbook 1 and place values in 2 | Excel Discussion (Misc queries) | |||
| Cell formated as text changes when copied | Excel Discussion (Misc queries) | |||
| If Statement - With Formated text | Excel Worksheet Functions | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Linear Mode
