Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello all! Using E02 on XP. Have linked cells in OutFile.xls 'reading' data
from InFile.xls. Rather than handwrite my cell mapping, how can I print the linked cells or the formulas? Example: InFile has: A B C 1 10.45 9.32 3.25 2 9.87 5.98 5.32 3 12.87 10.11 7.42 OutFile has: D L V 10 ='S:\[InFile.xls]P4'!A1 ='S:\[InFile.xls]P4'!B1 ='S:\[InFile.xls]P4'!C1 22 ='S:\[InFile.xls]P4'!A2 ='S:\[InFile.xls]P4'!B2 ='S:\[InFile.xls]P4'!C2 36 ='S:\[InFile.xls]P4'!A3 ='S:\[InFile.xls]P4'!B3 ='S:\[InFile.xls]P4'!C3 Rather than print my InFile and resulting values from OutFile (showing row and col numbers) and handwriting the mapping (=A1, =B2, etc.) I would like to print the formulas as you can see above. Hope I'm explaining this well enough so anyone reading can understand. Thanks in advance for any advice or help!!! -- Bonnie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you print a worksheet so the formulas appear? | New Users to Excel | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |