Filling question

M

mkerstei

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

mkerstei

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

Karthik

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
 
Top