hi, i have 2 excel sheets linked together in the same worksheet.
However, when i add a new row of data in the source sheet, the new row of data does not update in the destination worksheet.
(formula setting automatic calculation)
How do i automatically update the destination worksheet?
Solved by A. S. in 11 mins