If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|