C
Chi
Hi,
I have three workbooks that have identical structures or formats. I wanted
to summary to data from them into another workbook.
Ex: I would like to sum [Monder.xls] sheet1!C5 +[Teacher.xls]
sheet1!C5+[Student.xls] sheet1!C5 into [Total.xls] sheet1!C5.
Actuality, I would like to sum the value of C5 of Monder, Teacher and
Student workbooks into Total workbook.
I tried to use Consolidate function; however, the Total workbook was not
updated after I changed the C5 value of Monder workbook.
Please help
Chi Huynh
I have three workbooks that have identical structures or formats. I wanted
to summary to data from them into another workbook.
Ex: I would like to sum [Monder.xls] sheet1!C5 +[Teacher.xls]
sheet1!C5+[Student.xls] sheet1!C5 into [Total.xls] sheet1!C5.
Actuality, I would like to sum the value of C5 of Monder, Teacher and
Student workbooks into Total workbook.
I tried to use Consolidate function; however, the Total workbook was not
updated after I changed the C5 value of Monder workbook.
Please help
Chi Huynh