Basically I have no idea how but i have the following formula which references a cell on a previous sheet
=(INDIRECT(MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))-1&"!I5")
When i copy the formula down i want the formula to bring me I6 rather than I5
AND ALSO THE SAME FOR ACROSS I WANT IT TO BRING J5 NOT I5
Is there anyway i can do this without having to overtype the formula in each cell?
THANKS IN ADVANCE
PS I AM A COMPLETE NOVICE AND HAVE VERY LITTLE EXPERIENCE WITH EXCEL SO PLEASE GO EASY ON ME!
Bookmarks