How to copy a filtered range ?

G

gaftalik

Hi,

In a range of cells that i have filtered by
edit>go>special>formulas>ctrl+9, therefore remained only rows with
constant values, now that i need to copy these rows on a new book to
upgrade their values and repaste them on the original book in the same
column but without overwriting the hidden rows which contains formulas,
is that possible ?

Thank you very much .
 
D

Debra Dalgleish

When you paste, you paste into a contiguous block of cell -- hidden
cells are not ignored.

Perhaps you could label the rows, and sort them, then paste into the
block of cells.
 
Top