Posted to microsoft.public.excel.programming
|
|
Various workbook questions
"excelent" skrev:
"excelent" skrev:
if A5 = STK!
=INDIRECT(CELL("xxxxxxx",A5)&"D25") ' i think is ok now :-) geeee
"godonnygo" skrev:
Hi guys, I'm not neccessarily new to Excel but I'm looking to utilise
some more advance features in order to increase efficiency, so I'll be
firing off a few questions here, and appreciate any help :)
Firstly, I have cells with the words "STK", and another cell with the
word "RIC". There are sheets called "STK" and "RIC" that I want to
reference, but I want to reference the same cell on both sheets (ie,
D25). I could use "RIC!D25" and "STK!D25" but is there some way to
reference the cells, so it could be "A5"!D25?
I'll probably have more questions once I get over this hurdle ;)
--
godonnygo
------------------------------------------------------------------------
godonnygo's Profile: http://www.excelforum.com/member.php...o&userid=37124
View this thread: http://www.excelforum.com/showthread...hreadid=568580
|