Template Creation

T

Tee

I have the responsibility of generating a daily report via a text file that
is updated nightly. I want to have a template that would remain formatted
with column headings and other page formatting. Is there a way to create a
template whereas data can be added daily without always recreating the
spreadsheet?

Crazy question? I know.
 
S

sunnyland

There is a way that I think will work.

You must not have row or column numbers exceeding Excel maximum (6553
and 256)

Open a new workbook.
You will have to use the menu :
Data...
Import Text File
Selectionne the path of the file you want to use as data
Then selectionne where you want your data to go
May be leave a few lines if you intend to put a title or something.
Then the data will be there
Then format as you please
Then save as a template: extension xlt ie: data.xlt.
Close the file
Then if you open Excel and do new, it should be the name data under th
tab general
By clicking you will have a new workbook with data and formating.

You may want to practise a little at importing data to get familia
with the feature
Francoise;

+-------------------------------------------------------------------
|Filename: ImportingTextFileinATemplate.zip
|Download: http://www.excelforum.com/attachment.php?postid=4277
+-------------------------------------------------------------------
 
Top