Good morning Rose -
What you describe so far can be done with a macro in Excel.
You could start by recording a macro that does what you want it to do - from beginning to end.
Then modifying the macro so that you can apply it to any added row of data.
NOTE: Recorded macros do EXACTLY the same thing every time so to get what you want
it would have to modified.
One of you statements indicates that there may be a modification required before printing but after a save.as process,
this means that you may need to have 2 macros.
To start:
1. Open the workbook that you are going to add data to that you want to process
2. Select the cell that you are going to begin putting data into
3. Go to the TOOLS menu - Select Macro - Record New Macro - (I would select This Workbook) under the Store Macro in Dropdown)
The default macro name will be: Macro1
4. In an orderly fashion enter the new data
Save this workbook
5. Open a new Workbook and manipulate the new data into the new workbook as you want
6. Save the new workbook as needed
7. Process the data as you need to
8. Print the workbook
9. Save and close it
10. Click on the Stop Record button on the macro Toolbar.
To test this you would have to delete the New workbook that you saved and
remove the new data entered in the original work book - Save it
Run the Macro - Macro1
This will do EXACTLY what you recorded.
You will need to modify the macro to do the similar thing every time you run it but based on the row of data that you want it to.
Let me know if you need more information concerning this issue.
Thanks,
Jon Barchenger
--------------------
**From: rose2003 <
[email protected]>
**Subject: Generate new document with data
**Date: Tue, 18 Nov 2003 00:26:28 -0600
**Message-ID: <
[email protected]>
**Organization: ExcelTip
**User-Agent: ExcelTipForum
**X-Newsreader: ExcelTipForum
**X-Originating-IP: 209.206.0.186
**Newsgroups: microsoft.public.excel.worksheet.functions
**NNTP-Posting-Host: 69-56-172-122.theplanet.com 69.56.172.122
**Lines: 1
**Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
**Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.worksheet.functions:171974
**X-Tomcat-NG: microsoft.public.excel.worksheet.functions
**
*
I don't even know if this is possible in excel:
**
**First, enter additional information into an already existin
spreadsheet. Once the new data has been entered (say, several cells i
one row), a new document will be generated using an existing templat
which will contain choice information from that newly entered row o
data. This new document can be "saved as", and altered, and printed.
**
**thanx
-----------------------------------------------
**
