At 21:53 09/01/2008 -0500, Sheilah Noname wrote:
Information from File #1, Column B, Row 2 needs to be automatically
entered in File #2, Column M, Row 5. In Excel, I would go to the
destination cell, type "=" sign, then go to the source cell of File
#1, click on the appropriate cell and enter.
I have not been able to do this in your program. Can your program
accomplish this?
The simplest way to do this is probably to use Paste Special.
o Select the cell or cells in the first file that you need to be transferred.
o Copy the cells.
o Paste the contents into the second file, but use Edit | Paste
Special... (or Ctrl+Shift+V) instead of normal Paste.
o In the Paste Special dialogue, tick Link under Options.
You may want to look up the DDE function in the help text to see the
detail of how this works.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
