Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying values/formulas from only visable lines when filters are o
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
additional lines from filters | Excel Discussion (Misc queries) | |||
Drop and drag is copying values instead of formulas | Excel Worksheet Functions | |||
Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
copying formulas and not values | Excel Worksheet Functions | |||
Why do formulas turn to values wen copying in Excel 2003... | Excel Worksheet Functions |