Hello Guys have such a problem.
Pulled up all the names of the sheets into 1 column .
Screenshot 2022-02-13 013722.png
Now I need to use them in formula...
need to take the value from those sheets. for example D6 cell.
lets say that I need to take the D6 from the sheet ="sheet#1"!D60
can I use the sheet names as a core and add the symbols to multiple cells (where the sheet-name will stay as it is) and add symbols like ='(already written shee-tname)'!D60
I need to do this to all the sheets.
any ideas ?
Bookmarks