OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Linking Multiple Spreadsheets Part Duex

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
LarryL1066
Newbie
Newbie


Joined: 23 May 2012
Posts: 1

PostPosted: Wed May 23, 2012 10:57 am    Post subject: Linking Multiple Spreadsheets Part Duex Reply with quote

I tried searching the forums and found all kinds of responses. Some rude, some attempted to be helpful, and some never answered. So, posting here.

Using Linux w/Oo

Example......
Spreadsheet #1 = Data.ods
Tab on #1 = Initial
Cell being needed = B1

Spreadsheet #2 = Summary.ods
Tab on #2 = Summary-1
Cell needing to be used = A1

What I want to do is enter data in Data.ods and be able to see a summary of any info
in Summary.ods.

?? In #2, A1.... +Data.ods...Initial.B1 Something like that?
If #1, B1 contained 10, then Summary would pick it up.
If #1, B1 contained +sum(B2:B10), then Summary should still pick it up.

I used this as an example because if I see it done once, I can expand and modify to
allow me to do it with all my sheets. I can do this in Excel, but no longer use window


Respects...

Larry
[/u]
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 23, 2012 11:20 am    Post subject: Reply with quote

[Tutorial] External Links In Calc
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group