Lets say you enter Anna, Brian, Chris. in three cells. Is there a way
to write an equation in another group of cells that takes those values
and puts them in as part of an equation. An example would be have a
cell that says "=(whatever the command would be) likes apples. And
Anna, Brian, and Chris would be entered for that command for 3 separate
cells. Its hard to understand, help?


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=392210

Let's see if I understand.

A1: Anna
A2: Brian
A3: Chris

B1: =A1&" likes apples." <--Results in "Anna likes apples."
B2: =A2&" likes apples." <--Results in "Brian likes apples."
B3: =A3&" likes apples." <--Results in "Chris likes apples."


Is that what you're looking for?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=392210

Yes, precisely. I guess it would maybe help to see where I will end up
taking this type of equation as well. I am trying to have mulitple
items pull from other workbooks. The user would type in the name of
the workbook, in this case, Anna.xls, and my equations would put Anna
in front of .xls and create Anna.xls.


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=392210

This is a bit difficult to explain without an actual excel example, but
let me try to explain you in plane English.

Say you have three files
Anna.xls which has three sheets (Sheet1, Shee2 and Sheet3)
Brian.xls which has three sheets (Sheet1, Shee2 and Sheet3)
Chris.xls which has three sheets (Sheet1, Shee2 and Sheet3)

Now say you want to have a formula in cell A2 of sheet1 of file
anna.xls a value from cell A2 of sheet2 of file Brian.xls This is what
you should do:
Enter in cell A1of sheet1 of file anna.xls : Brian
Enter in cell A1of sheet1 of file anna.xls :
=INDIRECT("["&A1&".xls]Sheet2!A2")

What you have in cell A2 is the value of cell A2 of sheet2 of file
Brian.xls
Now change the value of cell A1of sheet1 of file anna.xls to Chris.
Cell A2 will now show the value of cell A2 of sheet2 of file Chris.xls
..

Now you have what you wanted. Users can now enter the name in cell A1
and the output from that file will be in cell A2.

You may possibly have an issue with this formula as the formula is
linked to another workbook and the indirect function will not pull data
from closed workbooks.

Thanks
Karthik Bhat
Bangalore