Q - Excel 2000: How to refer to worksheet in the same book?
Hi,
I have twelve sheets in the book called "Jan", "Feb" to "Dec". Now I will
use value in the two sheets by this format:
Row1 will contain columns, "jan", "feb", and etc.
Row2 should be like "=JAN!b2", "=FEB!b2", etc till "=Dec!b2".
Now the question is, how can I use reference, but not directly put in the
sheetname such as "Jan!b2"?
In another word, what I want to use is like "=Worksheets(cells(...))!b2".
Thanks for the help!
|