Dear All,
I have a table1 in sheet 1, on which I paste data from a table2 in sheet 2. Sheet 3 is the summary sheet, which have formulas referencing to table1 in sheet 1.
The problem is, if I paste data in table1, the formula does not work on Summary sheet.
But if I manually type in table1 then the formula works.
I have checked, there are no trailing space, the format of all the tables are set to "Text".
I really need your help. This is quite fustrating.
Thanks.
I have a table1 in sheet 1, on which I paste data from a table2 in sheet 2. Sheet 3 is the summary sheet, which have formulas referencing to table1 in sheet 1.
The problem is, if I paste data in table1, the formula does not work on Summary sheet.
But if I manually type in table1 then the formula works.
I have checked, there are no trailing space, the format of all the tables are set to "Text".
I really need your help. This is quite fustrating.
Thanks.