Here is a simple one that I just cannot get at.
StarOffice 8 Calc has 3 sheets per file yes.
Well, I am using sheet 1 for sales, sheet 2 for purchases, and I want to use sheet 3 for a profit / loss sheet thats automatically adjusted for me.
Now, I dont need to know the basic spreadsheet info, I think I have pretty much anything I need to know for single sheets... Where I am at a loss however, is trying to take values from sheet 1 and 2 and get them up for me in sheet 3
Can it be done?
If it can, and anyone can help me here, but if you could possibly point me in *** right direction maybe and perhaps give me the syntax for a simple sum if possible?
For example, if you could say add CELL A1 from sheet 1 with CELL A1 from sheet 2 and have it printed up in CELL A1 in sheet 3 perhaps? just to help me in reading what the sheet cell info is from each page, cos I am utterly lost
Thanks in advance
StarOffice 8 Calc has 3 sheets per file yes.
Well, I am using sheet 1 for sales, sheet 2 for purchases, and I want to use sheet 3 for a profit / loss sheet thats automatically adjusted for me.
Now, I dont need to know the basic spreadsheet info, I think I have pretty much anything I need to know for single sheets... Where I am at a loss however, is trying to take values from sheet 1 and 2 and get them up for me in sheet 3
Can it be done?
If it can, and anyone can help me here, but if you could possibly point me in *** right direction maybe and perhaps give me the syntax for a simple sum if possible?
For example, if you could say add CELL A1 from sheet 1 with CELL A1 from sheet 2 and have it printed up in CELL A1 in sheet 3 perhaps? just to help me in reading what the sheet cell info is from each page, cos I am utterly lost
Thanks in advance