Trick Of Changing Sheet Names In Formula Using Cell Reference

ExcelHelp
Hi,
This week I am taking an interesting question which I received from one of my participant. The question was, how can we use a cell reference to change the sheet names in our formulas.
Attached file illustrates how we are changing the sheet names in the formula by using a cell reference.
Wish you a great week ahead..
Thank you
Regards,
Hariharan Ramakrishnan
Microsoft Office Trainer / Consultant
1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute