| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect problem
Hiya guys and gals I have the following code; =INDIRECT("E2"!, E7) From what i understand from the help files this should work, unless i am being stupid (highly probable) What I want it to do is for the host cell to display the value of cell E7 from another worksheet, the name of the work sheet is in cell E2. Like i said i have searched the help files and this seems to be the method that is best. Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
=INDIRECT("'"&E2&"'!"&E7)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "superkopite" wrote in message ... Hiya guys and gals I have the following code; =INDIRECT("E2"!, E7) From what i understand from the help files this should work, unless i am being stupid (highly probable) What I want it to do is for the host cell to display the value of cell E7 from another worksheet, the name of the work sheet is in cell E2. Like i said i have searched the help files and this seems to be the method that is best. Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
=INDIRECT("Sheet2!"&E7)
Is your sheet called E2? You probably mean =INDIRECT(E2&"!"&E7) ?? -- Kind regards, Niek Otten "superkopite" wrote in message ... Hiya guys and gals I have the following code; =INDIRECT("E2"!, E7) From what i understand from the help files this should work, unless i am being stupid (highly probable) What I want it to do is for the host cell to display the value of cell E7 from another worksheet, the name of the work sheet is in cell E2. Like i said i have searched the help files and this seems to be the method that is best. Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
This seems to throw back an #ref error Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
Let's say cell E2 contains the text Sheet3
then =INDIRECT(E2 & "!" & "E7") is what you want. The trick is that between the parenthesis you want a string that represents an address -- Gary's Student "superkopite" wrote: Hiya guys and gals I have the following code; =INDIRECT("E2"!, E7) From what i understand from the help files this should work, unless i am being stupid (highly probable) What I want it to do is for the host cell to display the value of cell E7 from another worksheet, the name of the work sheet is in cell E2. Like i said i have searched the help files and this seems to be the method that is best. Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
hi Nek no that doesn't seem to work either The name of the worksheet is located in cell E7 Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
=INDIRECT(E2&"!E7")
If E2 contains a string with spaces (ie: "Sheet 1" instead of "Sheet1") you will need to use this formula =INDIRECT("'"&E2&"'"&"!E7") You want a text string that looks like this... Sheet1!E7 or 'Sheet 1'!E7 "superkopite" wrote: Hiya guys and gals I have the following code; =INDIRECT("E2"!, E7) From what i understand from the help files this should work, unless i am being stupid (highly probable) What I want it to do is for the host cell to display the value of cell E7 from another worksheet, the name of the work sheet is in cell E2. Like i said i have searched the help files and this seems to be the method that is best. Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
For some reason this is still returning a #ref error. It is also highlighting the E2 part of the formula to indicate that this the main part of the problem Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
I bet the name of the worksheet is misspelled in E2.
superkopite wrote: This seems to throw back an #ref error Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
Maybe this then
=INDIRECT("'"&E2&"'!E7") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "superkopite" wrote in message ... This seems to throw back an #ref error Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
Thanks a lot guys Sloth your forumla sorted it, I think it was because the worksheet name contain spaces, as dave suggested. Once again thank everyone Kind Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect problem
It's probably because whatever is in cell E7 doesn't look like a cell
reference. I think E7 just need to be in quotes as well, if I understand the problem right. "Dave Peterson" wrote: I bet the name of the worksheet is misspelled in E2. superkopite wrote: This seems to throw back an #ref error Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=515417 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
Linear Mode
