# Making 2 tabs in 1 workbook work together?

1. ## Making 2 tabs in 1 workbook work together?

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

2. ## Re: Making 2 tabs in 1 workbook work together?

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

3. ## Re: Making 2 tabs in 1 workbook work together?

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!!

5. ## Re: Making 2 tabs in 1 workbook work together?

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

6. ## Re: Making 2 tabs in 1 workbook work together?

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1