+ Reply to Thread
Results 1 to 6 of 6

Making 2 tabs in 1 workbook work together?

  1. #1
    Registered User
    Join Date
    07-31-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Exclamation 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
    Attached Files Attached Files
    Last edited by siroky25; 09-30-2010 at 11:17 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    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
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    07-31-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    20

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

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Making 2 tabs in 1 workbook work together?

    Why reply in first message? Add your reply as a new reply
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    07-31-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Making 2 tabs in 1 workbook work together?

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

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    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
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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