Hi Guys,
I have been using table functions recently but I dont know how to move the entire table to another tab without compromising the formula within the table( say cell C29 within the table from tab "Consolidated data" is actually linked to the data from another tab:so C29=HFM!D31-C8, HFM is the another tab... ). If I merely copy and paste the table, the formula will not work anymore - showing #REF! for each cell...So, is there any other way other than changing the formula to C29=HFM!$D$31-Consolidated data!$C$8?
I have been using table functions recently but I dont know how to move the entire table to another tab without compromising the formula within the table( say cell C29 within the table from tab "Consolidated data" is actually linked to the data from another tab:so C29=HFM!D31-C8, HFM is the another tab... ). If I merely copy and paste the table, the formula will not work anymore - showing #REF! for each cell...So, is there any other way other than changing the formula to C29=HFM!$D$31-Consolidated data!$C$8?