excel matching

  • Thread starter Thread starter CYWong
  • Start date Start date
C

CYWong

if i hv 3 excel files: A, B, C.
file C included the total information listed in file A &
B. Wht should i do if i want the information in file A & B
automatically copy to the C as an index, so that i can
change the details in A or B only.
then the changes can be shown in file C.
and i can easily add file D, E, F afterwards. their data
can also be transfered easily to C as well.
Thank you
 
Hi

You can use links. How exactly, depends on your data and what do you want to
get. You can mirror the data in workbooks A and B into workbook C, or you
can use various formulas with links as cell references, to calculate
summarized values.

Some examples:
='C:\My Documents\[Table1.xls]Sheet1'!A1
displays contents of cell A1 on workseet Sheet1 of workbook Table1.xls. When
A1 is empty, 0 is displayed.
=IF('C:\My Documents\[Table1.xls]Sheet1'!A1="","",'C:\My
Documents\[Table1.xls]Sheet1'!A1)
is the same, but when source cell is empty, nothing is displayed.
=SUM('C:\My Documents\[Table1.xls]Sheet1'!A1:A100)
displays the sum of values in range A1:A100 on sheet1 of source workbook.
etc.


Arvi Laanemets
 
Back
Top