| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Word Doc w/2 Excel Sheets - need formula to link them
Hello,
I have a Word Document in which there are 2 separate excel sheets embeded. I need a formula that will take the dollar sum from one sheet and display it in the other sheet in the same Word Document. Can someone help me? -- Tab |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Word Doc w/2 Excel Sheets - need formula to link them
Hi,
I guess you have embedded 2 separate Excel worksheet objects. If you create a workbook (in Excel itself) that does what you want on two worksheets the Copy & Paste Special each part (in Word Edit - Paste Special - Paste link - Microsoft Excel Worksheet Object). Then the two sheets will be linked. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Tab" wrote: Hello, I have a Word Document in which there are 2 separate excel sheets embeded. I need a formula that will take the dollar sum from one sheet and display it in the other sheet in the same Word Document. Can someone help me? -- Tab |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel whilst using the sumif formula to search for part of a word | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
| Excel should let me refer to the same formula on multiple sheets | Excel Worksheet Functions | |||
Linear Mode
