I am a fairly advanced excel user. However not a pro! Here is what is going on... I have a summary sheet, where i select a drop down. This drop down changes what sheet to pull from.
I am linking to the correct cell by using this: =INDIRECT("'"&$A$2&"'!"&CELL("address",B9))
It works great! however, everytime i insert a row on that summary tab this will happen: =INDIRECT("'"&$A$2&"'!"&CELL("address",B10))
So the cell references will automatically change as well. The absolute $B$9 stuff will not work. It continues to adjust the formula, based on how many columns I add.
Any thoughts??
Bookmarks