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

Hi Friends, I want to connect in such a way that whatever I will copy in source file should be copied automatically in target file. It would be great to get help from you.

I want to connect two excel documents... such that any change in figures or updation in the first one refreshes the figures in the second one. Have to use macro code... but what and how?

How do you link cells from one sheet to another in a workbook if the cells are in a sequence? I use the formula ='Sheet1'!C2, etc. but entering the formula for each cell is tedious. Is there a faster way if the cells are in sequence?

Hello. I have two documents, one is connected to a database and the second isn't. I wan't to connect these documents, so the numbers in the second document refresh every time the first one do. In the first document the data is wrote vertically and in the second the data is wrote horizontally. ...