How to connect one excel sheet to other excel sheet.

Moved from forum help

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.

That is sooo cool!

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

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

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

The syntax would be:

='[B BOOKKEEPING]SHEET1'!C2

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)?

A formula in Sheet2!C6 might be:

=IF(Sheet1!A1="duty", "P", "")

A formula in Sheet2!C6 might be:

=IF(Sheet1!A1="tariku", "P", "")

Tariku, what is the point of you duplicating my suggestion?

How to connect two excel sheet

I

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?

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.

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.

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.

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.

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.