Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zippy
 
Posts: n/a
Default Display cell contents in one xcell doc. from another xcell doc.

I am trying to display data from an xcell workbook "A"
in another xcell workbook "B".
I tried linking the cells using a hyperlink but all that did was pull the
entire sheet "A" into Sheet "B".
I also have used the array command to do this within the same document but
not outside the document.
Perhaps I'm not using either of these commands correctly, or there is a
different command, or there is no way of doing this.
Can anybody help me
thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Display cell contents in one xcell doc. from another xcell doc.

Try starting in the destination cell and using the formula ' =(cell
no)' .

eg : I want the contents of A1 on sheet1 to appear at C1 on sheet2. I
would click on C1, then type " =", then go to the cell you want to
appear, click on it, then hit enter. It will send you back to the
destination cell and the same information will appear there. Everytime
you change the data in sheet1, it will change automatically in Sheet2.
Hope that helped



Zippy wrote:
I am trying to display data from an xcell workbook "A"
in another xcell workbook "B".
I tried linking the cells using a hyperlink but all that did was pull the
entire sheet "A" into Sheet "B".
I also have used the array command to do this within the same document but
not outside the document.
Perhaps I'm not using either of these commands correctly, or there is a
different command, or there is no way of doing this.
Can anybody help me
thanks


Reply
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
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Cell contents don't display everything entered? treybreak Excel Discussion (Misc queries) 0 April 25th 06 05:09 PM
Display cell contents in the Header or Footer? yost42 Excel Discussion (Misc queries) 1 December 28th 05 02:59 PM
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 05:09 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 09:16 PM.

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

About Us

"It's about Microsoft Excel"