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