Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary.
maybe im going at in the wrong direction. please help.
I have a form on my call centre data sheet that is adding an information line each day. The line is picking up all my formulas for my metrics on who is answering the phone etc and feeding the info into a portal.
I am trying to set absolute cell location in a new sheet or in a sheet summary so i don't have to keep updating the the widgets data range daily.
I have tried $a$1 but as soon as you add a line or delete a line the link becomes $A$2 or unparseable.
please help
woody