Ask Experts Questions for FREE Help !
Ask
    vivekmishra3's Avatar
    vivekmishra3 Posts: 2, Reputation: 1
    New Member
     
    #1

    Jul 26, 2008, 09:09 PM
    How to connect one excel sheet to other excel sheet
    How to connect one excel sheet to other excel sheet.
    Fr_Chuck's Avatar
    Fr_Chuck Posts: 81,301, Reputation: 7692
    Expert
     
    #2

    Jul 26, 2008, 09:14 PM
    Moved from forum help
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Jul 26, 2008, 09:54 PM
    Do you mean have the contents of a cell on one sheet appear in a cell on another sheet?

    If so, it's easy if both sheets are part of the same workbook.

    1. On the second sheet, highlight the cell you want the data to appear in, to link TO.
    2. Enter an equal sign in that cell to start the formula, then use your mouse to switch to the first sheet and click on the cell that has the data in it already, the cell you want to link FROM.
    3. Press ENTER.
    4. Your cursor will return to the link TO cell and you will see that it now shows the data from the link FROM cell.

    That's the simple explanation. Here's the formula explanation.

    For one cell (A2) to show the contents of another cell (A1), the formula you enter cell A2 is =A1

    That works if the cells are both on the same sheet. If they are on separate sheets, you simply have to add the name of the sheet and and exclamation point to the formula.

    Sheet1, cell A1 is the data cell.
    On Sheet2, in cell A2 enter the formula =Sheet1!A1

    That's it.
    frangipanis's Avatar
    frangipanis Posts: 1,027, Reputation: 75
    Ultra Member
     
    #4

    Jul 30, 2008, 10:10 PM
    That is sooo cool!
    Appal's Avatar
    Appal Posts: 1, Reputation: 1
    New Member
     
    #5

    Dec 26, 2010, 12:52 AM
    Whenever U want to link two different sheets to each other follow the following...
    Copy the data whatever U want to link "the data" to another file or sheet,then,
    Select the desired cell where U want to paste the data and then press Alt+E+S+L and the Enter.

    Have a good time... Ur Appal...
    sunilp's Avatar
    sunilp Posts: 1, Reputation: 0
    New Member
     
    #6

    Mar 5, 2011, 12:55 AM
    For an example in 1seet I keep my sales bill in 2 shhe I keep my stock when I do billing in sheet 1 it automic change in stock
    paripink's Avatar
    paripink Posts: 1, Reputation: 1
    New Member
     
    #7

    Mar 24, 2011, 11:57 PM
    hello
    sir
    ***
    tell me
    how to link
    1 excel file to another excel file
    i telling u i all raddy use this formula =[b bookkeeping]sheet1'!$c$"
    but not working on the time
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #8

    Mar 26, 2011, 01:43 PM

    The syntax would be:

    ='[B BOOKKEEPING]SHEET1'!C2
    manalalessar's Avatar
    manalalessar Posts: 1, Reputation: 1
    New Member
     
    #9

    Oct 17, 2011, 05:27 AM
    I want to connect 2 cells in 2 different sheets but I eant to connect them by text is it possible or not?
    i.e when I write (duty in sheet 1 cell A1 the cell C6 in sheet 2 should be letter(P)?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #10

    Oct 17, 2011, 01:09 PM
    A formula in Sheet2!C6 might be:

    =IF(Sheet1!A1="duty", "P", "")
    tariku1611's Avatar
    tariku1611 Posts: 1, Reputation: 1
    New Member
     
    #11

    Dec 29, 2011, 05:18 AM
    A formula in Sheet2!C6 might be:

    =IF(Sheet1!A1="tariku", "P", "")
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #12

    Dec 30, 2011, 12:56 AM
    Tariku, what is the point of you duplicating my suggestion?
    vijaymani08's Avatar
    vijaymani08 Posts: 1, Reputation: 1
    New Member
     
    #13

    Jan 20, 2012, 08:11 AM
    How to connect two excel sheet
    jmatthews979's Avatar
    jmatthews979 Posts: 2, Reputation: 1
    New Member
     
    #14

    Jan 20, 2012, 09:49 AM
    I
    jmatthews979's Avatar
    jmatthews979 Posts: 2, Reputation: 1
    New Member
     
    #15

    Jan 20, 2012, 09:52 AM
    I would like to connect 2 excel spreadsheets within the same workbook I want sheet 1 to be a shipping record that can be edited and printed out and sheet 2 to track the data in sheet 1. Basically what I want is the data in sheet 2 to automically track the changing data in sheet 1 is this even possible?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #16

    Jan 21, 2012, 01:54 AM
    Most things are possible but your question isn't clear.

    It would be preferable for you to post your own question into a new thread of your own, attach your workbook where you have manually mocked up what you're trying to automate and point out where you'd like help.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
    costumes's Avatar
    costumes Posts: 1, Reputation: 1
    New Member
     
    #17

    Jan 26, 2012, 09:59 AM
    Is there any way to do this with an entire row. I'd also like the information to remain static, even if other rows are added or moved around. The formula stated above, doesn't work that way.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #18

    Jan 27, 2012, 07:40 AM
    Costumes, add a thread of your own, attach a workbook demonstrating some BEFORE/AFTER to show the exact problem formula you're trying to adjust.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
    Sanjay Tiwary's Avatar
    Sanjay Tiwary Posts: 2, Reputation: 1
    New Member
     
    #19

    Jan 9, 2013, 01:34 AM
    Hi I am Sanjay Tiwary

    Sir,

    I want to know that I enter the incoming date in sheet 1. and when we enter the outgoing data in sheet2 then outgoing data will deduct automatically in sheet1 data.
    Sanjay Tiwary's Avatar
    Sanjay Tiwary Posts: 2, Reputation: 1
    New Member
     
    #20

    Jan 9, 2013, 01:36 AM
    Hi I am Sanjay Tiwary

    Sir,

    I want to know that I enter the incoming date in excel sheet 1. and when we enter the outgoing data in excel sheet2 then outgoing data will deduct automatically in sheet1 data.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Connect two different sheet in Excel 2007 [ 6 Answers ]

I am using Excel 2007. I want to put the calculation part or the detail figure in one sheet. And I want to put the relating pi chart or some other graphical representation on some other sheet. How I would relate these two sheets so that when I make any changes in the figure in the first sheet...

Trying to calculate cash flow for accounts payable [ 0 Answers ]

The Sharpe Corporation: Detailed cash flow budget for the first seven months of 2004 The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows: January $90,000 February 120,000 March 135,000 April ...

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 [ 1 Answers ]

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 .

Tick Sheet for Excel [ 0 Answers ]

I am creating a "Table of Measurements" for a moving company in Excel, and they require that in the "# of pieces" cells that a number "1" or a similar character be placed in the cell rather than a "2" for two pieces or a "3" for three pieces, etc. So if there are 4 pieces, the cell would have...


View more questions Search