Making 2 tabs in 1 workbook work together?

**siroky25** · 09-30-2010, 01:01 AM

Hi again, I am trying to make 2 tabs in 1 workbook work together. What I am trying to do is to make a column in one tab that already has numbers in it, subtract another number in the second tab and put the number that it equals into a certain column on the second tab. If you need me to add my workbook to show you what I am talking about I can. If you could please help me with this, my workbook will be complete! Thanks in advance for the input. (IF YOU TAKE A LOOK AT MY WORKBOOK AND GO TO THE INDIVIDUAL SHEET IN THE BOTTOM. SCROLL OVER TO "FAWCETT A-1 AND WETTSTEIN 1-28) I NEED TO TAKE I8 IN THE FAWCETT A-1 SHEET AND HAVE THAT NUMBER WHICH IN THIS CASE IS 50 THEN SUBTRACT I8 IN WORKSHEET WETTSTEIN 1-28 WHICH IS 24 THEN HAVE THAT NEW NUMBER OF "26" PUT BACK IN THE FAWCETT A-1 WORKSHEET IN COLUMN I8) I HOPE THIS HELPS AND IS NOT TO CONFUSING BUT IF YOU COULD HELP ME FIGURE THIS OUT, I WOULD GREATLY APPRECIATE IT!!! Thanks in advance

**Palmetto** · 09-30-2010, 09:42 AM

You don't specify if you are wanting to subtract individual cell values or operate on the columns as a whole

Perhaps this . . . on a cell-by-cell calculation

=Sheet1!$A1-A1)

Or this, if you want to consider a range of cells in the columns
=Sum(Sheet1!$A1:$A10)-Sum($a1:$a10)

Both formula would need to be entered in the second tab. The "Sheet1!" part of the formula references the first sheet. An explicit reference is not required for the second sheet since Excel defaults to referencing cells on the active sheet in formulas.

If this is not what you need, post back and clarify more clearly your expected results.
Where Sheet1 is the

**siroky25** · 09-30-2010, 11:18 PM

Hey Palmetto, I put a reply to your messsage in my first message in caps and also added my workbook so you could see what i was working with. Thanks in advance!!

**royUK** · 10-01-2010, 01:30 AM

Why reply in first message? Add your reply as a new reply

**siroky25** · 10-01-2010, 03:27 AM

How about.....Why even say anything if your not gonna help!? thanks tho!

**romperstomper** · 10-01-2010, 03:36 AM

Oh dear...

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc