Array Formula? Lists?
 

Please help. What I want to do is have one cell pick up information in
another.
e.g. I have an expenses worksheet and want them to only use certain data so
that another forumla can add all the costs for that particular expense.
So they click on the cell and it brings up a list from another cell and they
select this. I am not sure what this is even called. Thanks.

Maybe datavalidation?

http://www.contextures.com/xlDataVal01.html

--
Regards,

Peo Sjoblom

(No private emails please)


"FB" wrote in message
...
Please help. What I want to do is have one cell pick up information in
another.
e.g. I have an expenses worksheet and want them to only use certain data
so
that another forumla can add all the costs for that particular expense.
So they click on the cell and it brings up a list from another cell and
they
select this. I am not sure what this is even called. Thanks.

Thanks. I put this on then went to new users and the answer was in there.
Yes it is validation. Much appreciate your time.

"Peo Sjoblom" wrote:

Maybe datavalidation?

http://www.contextures.com/xlDataVal01.html

--
Regards,

Peo Sjoblom

(No private emails please)


"FB" wrote in message
...
Please help. What I want to do is have one cell pick up information in
another.
e.g. I have an expenses worksheet and want them to only use certain data
so
that another forumla can add all the costs for that particular expense.
So they click on the cell and it brings up a list from another cell and
they
select this. I am not sure what this is even called. Thanks.