Various workbook questions
 

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

Various workbook questions
 

if A5 = STK!D25

=INDIRECT(CELL("xxxxxx",A5))

where xxxxx in Dennish is 'indhold' but not sure in English maby value


"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

Various workbook questions
 

if A5 = STK!

=INDIREKTE(CELLE("xxxxxxx";A5)&"D25")


"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

Various workbook questions
 

"excelent" skrev:

if A5 = STK!

=INDIREKTE(CELLE("xxxxxxx",A5)&"D25")


"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

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

Various workbook questions
 

Next time just click "Edit" mate ;)

'[image: http://img139.imageshack.us/img139/3623/porjb6.png]'
(http://imageshack.us)

That's what I mean...is there a way to refer to the sheet according to
whats in cell A105?


--
godonnygo
------------------------------------------------------------------------
godonnygo's Profile: http://www.excelforum.com/member.php...o&userid=37124
View this thread: http://www.excelforum.com/showthread...hreadid=568580

Various workbook questions
 

figured out that u dont ned the CELL part in formula just:

=INDIRECT(A105&"!D55")

by he way, how do u edit, where is the edit button ?



"godonnygo" skrev:


Next time just click "Edit" mate ;)

'[image: http://img139.imageshack.us/img139/3623/porjb6.png]'
(http://imageshack.us)

That's what I mean...is there a way to refer to the sheet according to
whats in cell A105?


--
godonnygo
------------------------------------------------------------------------
godonnygo's Profile: http://www.excelforum.com/member.php...o&userid=37124
View this thread: http://www.excelforum.com/showthread...hreadid=568580

Various workbook questions
 

After you post, next to "Quote" there should be an "Edit" button.

Thanks for the help so far mate


--
godonnygo
------------------------------------------------------------------------
godonnygo's Profile: http://www.excelforum.com/member.php...o&userid=37124
View this thread: http://www.excelforum.com/showthread...hreadid=568580

Various workbook questions
 

Anyone got any idea on how to separate the columns?

Also, I have lists of values that contain data like "8.7 (55)" within
the one cell. I know how to go Data Text to Columns to separate them,
but I can't separate all three values at once this way ("8", "7" and
"55"). Not only this, but it overwrites whatever is in the right most
cells


--
godonnygo
------------------------------------------------------------------------
godonnygo's Profile: http://www.excelforum.com/member.php...o&userid=37124
View this thread: http://www.excelforum.com/showthread...hreadid=568580

Various workbook questions
 

Up...any help on this guys?


--
godonnygo
------------------------------------------------------------------------
godonnygo's Profile: http://www.excelforum.com/member.php...o&userid=37124
View this thread: http://www.excelforum.com/showthread...hreadid=568580