Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
Add workbook & save immediately (& 2 related questions) | Excel Programming | |||
Closing Workbook without Questions | Excel Programming | |||
Workbook Set-Up Questions | Setting up and Configuration of Excel | |||
Questions with using another workbook for data source | Excel Programming |