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

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