software

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.


quot;IrishKBquot; gt; wrote in message
...
gt; What formula can I make or choose to have cell with text in it show up in
gt; another cell automatically? What I'm trying to say is I have a
gt; spreadsheet
gt; with a filter on for the data I want to pull. Now in another cell (that
gt; is
gt; blank) I want the data that is being filtered to be displayed in the blank
gt; cell (all text Example: Meadowlands). You know when you do auto filter
gt; and
gt; select certain data. I just want the blank cell to have the selected data
gt; (just in the cell) from the filter. I don't know if this makes any sense,
gt; but I am going crazy trying to figure this out. Thank you in advance for
gt; any
gt; 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 - You are great - Somthing so simple - just...well... Thanks

quot;Doug Kanterquot; wrote:

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

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.

quot;IrishKBquot; gt; wrote in message
...
gt; Doug - You are great - Somthing so simple - just...well... Thanks
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt;
gt;gt; quot;IrishKBquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; What formula can I make or choose to have cell with text in it show up
gt;gt; gt; in
gt;gt; gt; another cell automatically? What I'm trying to say is I have a
gt;gt; gt; spreadsheet
gt;gt; gt; with a filter on for the data I want to pull. Now in another cell
gt;gt; gt; (that
gt;gt; gt; is
gt;gt; gt; blank) I want the data that is being filtered to be displayed in the
gt;gt; gt; blank
gt;gt; gt; cell (all text Example: Meadowlands). You know when you do auto filter
gt;gt; gt; and
gt;gt; gt; select certain data. I just want the blank cell to have the selected
gt;gt; gt; data
gt;gt; gt; (just in the cell) from the filter. I don't know if this makes any
gt;gt; gt; sense,
gt;gt; gt; but I am going crazy trying to figure this out. Thank you in advance
gt;gt; gt; for
gt;gt; gt; any
gt;gt; gt; help.
gt;gt;
gt;gt; The most basic way of making one cell show the contents of another is
gt;gt; simply
gt;gt; to type a formula like this:
gt;gt;
gt;gt; =B7
gt;gt; ....where B7 contains the data, and the formula is placed in the cell
gt;gt; where
gt;gt; you want to mirror B7's contents. I don't use filtering, so I can't say
gt;gt; whether this will work for you, but it's a starting point.
gt;gt;
gt;gt;
gt;gt;