Copying values/formulas from only visable lines when filters are o

E

excelchallenged

I have huge spreadsheet with dozens of columns, and filters are on most
columns.

In my last column, I want to systematically post the results only of
specific lines while specific (and sometimes multiple) filters are on. Also,
the last column is filtered for "blanks" only, so if a line already has a
value from copying a prior filter value that value does not get overwritten
by a more recent filtered value. I have done this for years in excel 2003,
but in 2007 the values from the non-visible lines copy over to my last column
as well, which I don't want.

How can I ensure only the values of the visible lines are copied to the last
column?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

series of formulas to get to one formula 0
adding multiple values from matched search results 3
Problem with filtering columns in Excel 2007 1
conditional formatting, filtering then copying to another sheet 0
I copied Visible Cells Only, but it pastes only the first cell 1
Identify letters but not spaces 2
How to list cells from two sheets that has different values in theirneighboring column? 8
How do I filter data by more than one column in excel 0

Top