Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
letters for numbers
all i am trying to reference worksheets using the INDIRECT function.
e.g. Sheet1, Sheet2, Sheet3 i am using formula = indirect("sheet"&a1&"BJ102") to refer to one of the sheets. A1 will have either 1, 2, or 3 representing the sheet. I want to copy this formula accross the row but i really want BJ to change with every cell i.e. the next formula on the right should really read = indirect("sheet"&a1&"BK102") without physically changing BJ to BK. What is the best way to do this? thanks much. RK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
letters for numbers
Hi RK
See this page http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rk0909" wrote in message ... all i am trying to reference worksheets using the INDIRECT function. e.g. Sheet1, Sheet2, Sheet3 i am using formula = indirect("sheet"&a1&"BJ102") to refer to one of the sheets. A1 will have either 1, 2, or 3 representing the sheet. I want to copy this formula accross the row but i really want BJ to change with every cell i.e. the next formula on the right should really read = indirect("sheet"&a1&"BK102") without physically changing BJ to BK. What is the best way to do this? thanks much. RK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
Numbers to Letters? | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
Letters = Numbers | Charts and Charting in Excel | |||
corresponding numbers and letters | Excel Discussion (Misc queries) |