Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

OpenOffice: How to display cell from sheet 2 on sheet 1?


  • Please log in to reply
7 replies to this topic

#1 juvanya

juvanya

  • Members
  • 84 posts
  • OFFLINE
  •  
  • Local time:01:52 PM

Posted 28 January 2011 - 03:44 PM

This is OpenOffice, but maybe Excel formulŠ are similar...

Anyway, I have my main spreadsheet on sheet 1, but there is a cell on sheet 2 I want to have display on sheet 1 as well. The cell on sheet 2 will change over time, so I cant just copy the value. I know if its on the same sheet, I could put =C5 or whatever the case may be, but I dont know how to format it to get data from another sheet.

Can anyone help? Thanks :)

BC AdBot (Login to Remove)

 


#2 Eyesee

Eyesee

    Bleepin Teck Shop


  • BC Advisor
  • 3,541 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:In the middle of Kansas
  • Local time:01:52 PM

Posted 28 January 2011 - 03:49 PM

Exactly the same way as Excel
Start your formula in sheet 1 and then link it to sheet 2
In the beginning there was the command line.

#3 FayB

FayB

  • Members
  • 46 posts
  • OFFLINE
  •  
  • Gender:Not Telling
  • Local time:01:52 PM

Posted 28 January 2011 - 07:34 PM

In Excel I think it would be: =sheet2!C5

#4 Eyesee

Eyesee

    Bleepin Teck Shop


  • BC Advisor
  • 3,541 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:In the middle of Kansas
  • Local time:01:52 PM

Posted 29 January 2011 - 03:03 PM

Thats exactly right
In the beginning there was the command line.

#5 juvanya

juvanya
  • Topic Starter

  • Members
  • 84 posts
  • OFFLINE
  •  
  • Local time:01:52 PM

Posted 10 February 2011 - 02:29 AM

That doesnt seem to work. It says #NAME?

#6 FayB

FayB

  • Members
  • 46 posts
  • OFFLINE
  •  
  • Gender:Not Telling
  • Local time:01:52 PM

Posted 10 February 2011 - 09:57 AM

It works for me in Excel but I currently do not have open office and can't test it there
But in Execl if I leave out the ! I get the results you do.
Make sure you have it like =sheet2!C5 not =sheet5C5

Post back and let us know. If that is not the problem, maybe someone else can help you.

#7 Barilla

Barilla

  • Members
  • 197 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:07:52 PM

Posted 11 February 2011 - 03:18 AM

Try:
=Sheet2.A1
replace A1 with the cell you want to use.

/Barilla

#8 juvanya

juvanya
  • Topic Starter

  • Members
  • 84 posts
  • OFFLINE
  •  
  • Local time:01:52 PM

Posted 18 February 2011 - 06:47 AM

Try:

=Sheet2.A1
replace A1 with the cell you want to use.

/Barilla

Bingo. Thanks so much! :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users