Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2009, 11:11 PM
freelance_jhoe26 freelance_jhoe26 is offline
Novice
Help me asap... I need this for my exam
 
Join Date: Apr 2009
Posts: 6
freelance_jhoe26 is on a distinguished road
Default Help me asap... I need this for my exam

another problem i have to figured out is this one...



a.Using Microsoft Excel, create a multiple sheets that perform computations across sheets.




any help will be very much i appreciated..


please... i need this asap!!!

Last edited by Bird_FAT; 04-22-2009 at 11:55 PM.
Reply With Quote
  #2  
Old 04-19-2009, 01:23 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Help me asap... I need this for my exam Help me asap... I need this for my exam Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Question ???

I'm sorry, but this question makes no sense!
Quote:
create a multiple sheets that perform computations across sheets
Sheets don't perform computations ?? Formulas do !!
And, if you need help creating formulas, you will need to give us some data and row/column headings to work with.

So please - if you wish help on this forum can you rephrase your question and tell us:

What is the situation that you are in
What data do you have for us to work with
What is it exactly that you want to be able to do
What have you already tried

With this information, we may be able to help you - otherwise we will all just have to look on in despair!
Reply With Quote
  #3  
Old 04-19-2009, 01:34 AM
freelance_jhoe26 freelance_jhoe26 is offline
Novice
Help me asap... I need this for my exam
 
Join Date: Apr 2009
Posts: 6
freelance_jhoe26 is on a distinguished road
Default hmmm this is the scenario

This is the sample attachment Sampple.xls
hope you can help me
Reply With Quote
  #4  
Old 04-19-2009, 02:24 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Help me asap... I need this for my exam Help me asap... I need this for my exam Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by Bird_FAT View Post
So please - if you wish help on this forum can you rephrase your question and tell us:

  • What is the situation that you are in
  • What data do you have for us to work with
  • What is it exactly that you want to be able to do
  • What have you already tried

With this information, we may be able to help you - otherwise we will all just have to look on in despair!
Having said that - I'll make a guess (but no promises!):

The file you uploaded requires a formula in SHEET Expenses, CELL B6 that will show the total in SHEET Expenses in Company, CELL B11!

If that is all you are looking for then the answer is:
Code:
='Expenses in Company'!B11
To make this, you would click on SHEET Expenses, CELL B6 and do the following:

  • Make sure the cell is the active one
  • Type '=' (without the apostrophes)
  • Click on the 'Expenses in Company' tab
  • Click on CELL B11
  • Press enter
If I have failed to answer your question correctly, then refer to the quote at the top of the post and rephrase your question using the four lines in the list!!
Reply With Quote
  #5  
Old 04-19-2009, 02:39 AM
freelance_jhoe26 freelance_jhoe26 is offline
Novice
Help me asap... I need this for my exam
 
Join Date: Apr 2009
Posts: 6
freelance_jhoe26 is on a distinguished road
Default hmmm...

maybe im not that good to explain it to you..

as you can see there is another sheet named summary...

what i need to do is once i updated an amount in expense company... that update also must reflect on the other sheet named summary...

hope this one could do...
Reply With Quote
  #6  
Old 04-19-2009, 02:43 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Help me asap... I need this for my exam Help me asap... I need this for my exam Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by freelance_jhoe26 View Post
as you can see there is another sheet named summary...

what i need to do is once i updated an amount in expense company... that update also must reflect on the other sheet named summary...
Then follow the instructions - any time the Expenses sheet changes, so will the Summary!!

Quote:
The file you uploaded requires a formula in SHEET Expenses, CELL B6 that will show the total in SHEET Expenses in Company, CELL B11!

If that is all you are looking for then the answer is:

Code:
='Expenses in Company'!B11

To make this, you would click on SHEET Expenses, CELL B6 and do the following:

  • Make sure the cell is the active one
  • Type '=' (without the apostrophes)
  • Click on the 'Expenses in Company' tab
  • Click on CELL B11
  • Press enter
Reply With Quote
  #7  
Old 04-19-2009, 02:52 AM
freelance_jhoe26 freelance_jhoe26 is offline
Novice
Help me asap... I need this for my exam
 
Join Date: Apr 2009
Posts: 6
freelance_jhoe26 is on a distinguished road
Default THANKS... but.....

Yes.. yes... your right!!! THANKS



do you know how to solve my other problem in the word?!??? please... or any idea...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help me asap... I need this for my exam freelance_jhoe26 Word 3 04-19-2009 04:19 AM
Please help with Sum formula to add totals by State! asap dutch4fire23 Excel 0 07-28-2006 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft