LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bonnie
 
Posts: n/a
Default Need to print formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you print a worksheet so the formulas appear? twoodard New Users to Excel 1 June 7th 05 07:21 PM
One spreadsheet cell won't print but shows up in print preview? Sally Excel Discussion (Misc queries) 1 May 26th 05 07:06 PM
Dynamic Print Range Help waxwing Excel Worksheet Functions 2 February 21st 05 03:47 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"