PDA

View Full Version : [ubuntu] [SOLVED] Spreadsheet Question



kincora
May 23rd, 2008, 08:43 PM
I am new to ubuntu. I am using Open Office spreadsheet. I am familiar with excel and this performs the same way.

I have created a spreadsheet with five sheets and a total sheet. All is programmed well on the five sheets. I would like help to move the totals from each spreadsheet to the total sheet.

Can anyone help?

Derek

forestpixie
May 23rd, 2008, 09:23 PM
I use = in the cell of sheet2 that I want total from sheet1 to appear in, then select cell. Same as it is in excel I thought

Appears as =Sheet1.CellNumber in formula bar

Is that what you mean?

kincora
May 24th, 2008, 07:49 PM
yes, thank you for all your help, much appreciated.