Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded Excel sheets over 2 pages
Needing to embed a spreadsheet into a word document that can continue over 2
or more pages to create a bill format where calculations and formulae can be used. Word tables don't seem to be user friendly with sub totals and totals so trying to use excel embedded |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded Excel sheets over 2 pages
Dear MultiM:
A: Why don't you just use Excel and forget about word? You can basically do all the stuff in Excel and also link the word document into Excel. B: If that doesn't work and you really need to use word that link the Excel worksheet three or more times. I can see that you may have problems if there is no fixed length with blank pages. Good luck. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "MultiM" wrote: Needing to embed a spreadsheet into a word document that can continue over 2 or more pages to create a bill format where calculations and formulae can be used. Word tables don't seem to be user friendly with sub totals and totals so trying to use excel embedded |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded Excel sheets over 2 pages
I would simply use Excel! Create a sheet, complete with letterhead detail.
Then use a macro to bring info across from your calculation sheet to your bill sheet. I have done this for quotations, and it works great! You do not have problems with blank pages or such, and it looks as good as a Word document any day. If you would like to see a copy of my quotation sheet, let me know. -- Hth Kassie Kasselman Change xxx to hotmail "MultiM" wrote: Needing to embed a spreadsheet into a word document that can continue over 2 or more pages to create a bill format where calculations and formulae can be used. Word tables don't seem to be user friendly with sub totals and totals so trying to use excel embedded |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
Print embedded charts from several sheets | Charts and Charting in Excel | |||
How do I make an embedded excel spreadsheet flow over pages in wo | Excel Discussion (Misc queries) | |||
Selecting Embedded charts in Active Sheets programmatically | Charts and Charting in Excel |