A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

linking pages in two different work books



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2004, 10:08 PM
modicum21
external usenet poster
 
Posts: n/a
Default linking pages in two different work books

trying to link two different pages in two seperate workbooks.
filling in statistical data in first workbook in
specific fields. then having to open the next work book and inserting
the same in formation again. don't wnat to be redundent and would like
to populate worksheet in workbook 2 with the same input from worksheet
in work book 1


---
Message posted from http://www.ExcelForum.com/

  #2  
Old April 28th, 2004, 04:26 PM
Marioette
external usenet poster
 
Posts: n/a
Default linking pages in two different work books

I am also in need of this ability.
I have a list on one sheet and a chart with the names from the list on
another, same workbook. I have been linking each individual name from
the list to their location on the chart. When I delete the name it
clears it, but I need it to also be able to move names to a new
location on the chart when that name goes to a new department heading.


---
Message posted from http://www.ExcelForum.com/

  #3  
Old May 26th, 2004, 05:06 PM
123
external usenet poster
 
Posts: n/a
Default linking pages in two different work books

it's very simple to link sheets in this way, just enter the = sign in
the cell you want the data to apper in, then click on the cell which
contians the data you want to link:
see help on linking workbooks for more info
it's easy really


---
Message posted from http://www.ExcelForum.com/

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:27 PM.


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