DISQUS

garrison · 1 year ago

how to reference the name of worksheet as a valuable, ie. from the content of another cell, thx.?
joe · 6 months ago

thank you u saved my life
Michael · 2 weeks ago

can the worksheet be referenced other than by name? i'd like to get data from one sheet to the left, regardless of its name. i'm using =INDIRECT(ADDRESS... etc to enter a value in a cell, and a macro to name the worksheets based on that cell. it all works fine, but when i copy the sheet data to a new sheet, i have to replace the worksheet name in the cell formula, which kind of defeats the purpose of all the coding. thanks!