| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exporting excel worksheet to word | Links and Linking in Excel | |||
| Refer to Excel Worksheet by its name | Excel Worksheet Functions | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Threaded Mode
