Ill try to explain what i need to do:
I have a name written on a cell, for example name "sheet1" writen on A1. That name is variable.
So, for cell B1 for example, i need it to be equal to cell C1 from "sheet1". That would be like:
B1='sheet1'!C1
No problem there. But now, i need to let the sheet to be a variable, so i can write on A1: "sheet2", and the formula changes to:
B1='sheet2'!C1
Hope i did make myself understand, ill appreciate any help! Thanks! Greetings!
Bookmarks