G
Girish Tare
Hi,
I want an excel formula to work automatically in hte way that if say i have
2 tabs in a workbook; Sheet1 & Sheet2 and there is a formula in sheet2 that
is capturing value from sheet1. But if i create a copy of sheet2 as sheet3;
the formula in sheet3 should automatically capture data from sheet2.
e.g.: here is a formula in sheet2 saying "='sheet1'!AA1+AA1" and if i copy
sheet2 as sheet3 in the same workbook the formula in sheet3 should get
convertered to "='sheet2'!AA1+AA1".
I tried this lot of times but couldn't get the answer.
I want an excel formula to work automatically in hte way that if say i have
2 tabs in a workbook; Sheet1 & Sheet2 and there is a formula in sheet2 that
is capturing value from sheet1. But if i create a copy of sheet2 as sheet3;
the formula in sheet3 should automatically capture data from sheet2.
e.g.: here is a formula in sheet2 saying "='sheet1'!AA1+AA1" and if i copy
sheet2 as sheet3 in the same workbook the formula in sheet3 should get
convertered to "='sheet2'!AA1+AA1".
I tried this lot of times but couldn't get the answer.