View Single Post
  #1   Report Post  
Jim
 
Posts: n/a
Default 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!