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.