Excel cell question

[IrishKB]

What formula can I make or choose to have cell with text in it show up in
another cell automatically? What I'm trying to say is I have a spreadsheet
with a filter on for the data I want to pull. Now in another cell (that is
blank) I want the data that is being filtered to be displayed in the blank
cell (all text Example: Meadowlands). You know when you do auto filter and
select certain data. I just want the blank cell to have the selected data
(just in the cell) from the filter. I don't know if this makes any sense,
but I am going crazy trying to figure this out. Thank you in advance for any
help.

[Doug Kanter]

"IrishKB" <IrishKB@discussions.microsoft.com> wrote in message
news:139BE93E-F588-4CBC-A96B-7DE8E1BBCC90@microsoft.com...
> What formula can I make or choose to have cell with text in it show up in
> another cell automatically? What I'm trying to say is I have a
> spreadsheet
> with a filter on for the data I want to pull. Now in another cell (that
> is
> blank) I want the data that is being filtered to be displayed in the blank
> cell (all text Example: Meadowlands). You know when you do auto filter
> and
> select certain data. I just want the blank cell to have the selected data
> (just in the cell) from the filter. I don't know if this makes any sense,
> but I am going crazy trying to figure this out. Thank you in advance for
> any
> help.

The most basic way of making one cell show the contents of another is simply
to type a formula like this:

=B7
....where B7 contains the data, and the formula is placed in the cell where
you want to mirror B7's contents. I don't use filtering, so I can't say
whether this will work for you, but it's a starting point.

[IrishKB]

Doug - You are great - Somthing so simple - just...well... Thanks

"Doug Kanter" wrote:

>
> "IrishKB" <IrishKB@discussions.microsoft.com> wrote in message
> news:139BE93E-F588-4CBC-A96B-7DE8E1BBCC90@microsoft.com...
> > What formula can I make or choose to have cell with text in it show up in
> > another cell automatically? What I'm trying to say is I have a
> > spreadsheet
> > with a filter on for the data I want to pull. Now in another cell (that
> > is
> > blank) I want the data that is being filtered to be displayed in the blank
> > cell (all text Example: Meadowlands). You know when you do auto filter
> > and
> > select certain data. I just want the blank cell to have the selected data
> > (just in the cell) from the filter. I don't know if this makes any sense,
> > but I am going crazy trying to figure this out. Thank you in advance for
> > any
> > help.
>
> The most basic way of making one cell show the contents of another is simply
> to type a formula like this:
>
> =B7
> ....where B7 contains the data, and the formula is placed in the cell where
> you want to mirror B7's contents. I don't use filtering, so I can't say
> whether this will work for you, but it's a starting point.
>
>
>

[Doug Kanter]

You're welcome! By the way, the Excel help system is pretty good for
learning these things. Press F1 - voila! Sometimes it thinks you want help
with a specific chore, so it takes you to that part of the help system, but
it's easy to get to the very beginning.

"IrishKB" <IrishKB@discussions.microsoft.com> wrote in message
news:356499C2-163E-471C-A755-B9E3DBA88000@microsoft.com...
> Doug - You are great - Somthing so simple - just...well... Thanks
>
> "Doug Kanter" wrote:
>
>>
>> "IrishKB" <IrishKB@discussions.microsoft.com> wrote in message
>> news:139BE93E-F588-4CBC-A96B-7DE8E1BBCC90@microsoft.com...
>> > What formula can I make or choose to have cell with text in it show up
>> > in
>> > another cell automatically? What I'm trying to say is I have a
>> > spreadsheet
>> > with a filter on for the data I want to pull. Now in another cell
>> > (that
>> > is
>> > blank) I want the data that is being filtered to be displayed in the
>> > blank
>> > cell (all text Example: Meadowlands). You know when you do auto filter
>> > and
>> > select certain data. I just want the blank cell to have the selected
>> > data
>> > (just in the cell) from the filter. I don't know if this makes any
>> > sense,
>> > but I am going crazy trying to figure this out. Thank you in advance
>> > for
>> > any
>> > help.
>>
>> The most basic way of making one cell show the contents of another is
>> simply
>> to type a formula like this:
>>
>> =B7
>> ....where B7 contains the data, and the formula is placed in the cell
>> where
>> you want to mirror B7's contents. I don't use filtering, so I can't say
>> whether this will work for you, but it's a starting point.
>>
>>
>>