[Solved]Calc Formula between sheets help please

TeddieS · General User Joined: 14 Jun 2012 Posts: 5

I use Calc to enter the fuel receipts for the company I work for. I have Cash, Charge and Checks. Once there we have to total each month.
What my issue is I need a sheet with all the final total for each months Fuel. (Cash, Charge, etc...)
How do I link between all 12 sheets and enter just the totals for each month. I really don't feel like manually typing all this in. Do I highlight the cell, move to the sheet Click the cell I want the total from or what? I am so tired of dealing with these idiots at work I need to get it done now.
Each completed month ends on a different row so I can do a total at the top of each sheet that is in the same position, just a different monthly sheet.
Any help would be appreciated.
Teddie

PS it needs to be pretty simple because I am not an expert with this program!!!!

scsisys · OOo Enthusiast Joined: 17 Dec 2009 Posts: 164

TeddieS · General User Joined: 14 Jun 2012 Posts: 5

Okay my sheets are named by month and year.
I only need the complete total of all receipts for each month. Not the totals of all cash, etc...
I just need to link 1 cell from each sheet.
This is the actual name of the actual sheet. 'Jan 2011 '.A2
It isn't linking or anything and it is driving me batty, if I can get this then I can set this up for good and not keep having to do this month after month year after year. ARG

scsisys · OOo Enthusiast Joined: 17 Dec 2009 Posts: 164

TeddieS · General User Joined: 14 Jun 2012 Posts: 5

Hi I am not trying to add them all up just want 1 cell from each sheet reported.
January $2800.73
February $4678.38

These totals are already calculated on each monthly sheet I just want to me able to link them straight to the Totals page.
I don't know if I didn't make that clear, all the amounts on each sheet are totaling fine. I just cant seem to get the cell A2 for each month to post on the main sheet.
I have tried everything I can think of and every way to write it out, hyperlinking too. Just can't it to report there. Keep getting an error.

ozzie · Posted: Thu Jun 14, 2012 7:50 pm Post subject:

Easiest way, on your summary sheet where you want the January total type = and then without doing anything else move to the January sheet and click once only on the A2 cell and then click enter. repeat as required
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

TeddieS · General User Joined: 14 Jun 2012 Posts: 5

That was it thanks!!!!
I knew there was some easy way to do this. I used to be able to do it in Excel but haven't worked with it in so long!!!
Many Many Thanks again!!