View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

Hi Bonnie,

CTRL`


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Bonnie" wrote in message
...
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