Various workbook questions

[godonnygo]

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

 

[Guest]

if A5 = STK!D25

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

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


"godonnygo" skrev:

 

[Guest]

if A5 = STK!

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


"godonnygo" skrev:

 

[Guest]

"excelent" skrev:

if A5 = STK!

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


"godonnygo" skrev:

 

[Guest]

"excelent" skrev:

"excelent" skrev:

 

[godonnygo]

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?

 

[Guest]

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:

 

[godonnygo]

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

Thanks for the help so far mate

 

[godonnygo]

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]

Up...any help on this guys?