How to copy a filtered range ?
 

Hi,

In a range of cells that i have filtered by
editgospecialformulasctrl+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 .


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=488013

How to copy a filtered range ?
 

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.

gaftalik wrote:
Hi,

In a range of cells that i have filtered by
editgospecialformulasctrl+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 .




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

How to copy a filtered range ?
 

It could be an idea .Thank you


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=488013