Dear All, (Sorry my question is not about word processor)

I want to ask that how can be the data added automaticall to from one excel sheet to another. For e.g I have one excel sheet by the name ex1.xls and 2nd is ex2.xls. Let suppose I want to add something in ex1.xls and want the same addition in ex2.xls

Kindly Guide me Properly.

Regards!
Ahmed

>Moved to Spreadsheets<

Normally, inside a single document, for one cell to mirror the contents of another, you simply create a formula asking for the data from another cell. For a cell to show the contents of cell A1, the formula is:

=a1

If you want to show contents from another SHEET in the same workbook, you have it include the sheet name as well as the cell reference:

=Sheet1!A1

Finally, your question, if you want info from completely different workbook to display, you have to include the complete filename in the formula:

='[Customers.xls]Sheet1'!$A$1

Notice the cell reference is no longer A1, it is $A$1, meaning it is an absolute reference. Also, this formula assumes both documents reside in the same folder on your hard drive. If they DON'T, you will need to include the fullpathname to the document in your formula:

='C:\Documents and Settings\Jerry2\My Documents\\[Customers.xls]Customers'!$A$1

By the way, the EASIEST way to create these links is to:
Open both Excel documents
In the target document, select the target cell and press = to start your formula
Now switch over to the source document and click the source cell
The formula has created itself complete with pathname and filename reference...press ENTER
(You may not actually SEE the full pathname until you save and close your document, that's ok)
Make other cell connections as required
Close the source document
Save target document

NOTE: Every time you open the target document now, it will warn you that it found links to external documents and ask for permission to update the data. You should always say YES.

Just a word on terms here. A WORKSHEET is a grouping of rows and columns within a WORKBOOK. A WORKBOOK is a separate XLS file. So if you want to reference a value in a cell in an external Workbook, you need to refer to the workbook name (and path, if in another folder).