Copy data in filtered list

A

Andre Croteau

Hello!

I have a list of data in filtered mode, where the results show in "OLD"
Sheet Cells A1, A3 and A5 (row 2 & 4 are hidden)
Suppose I have data in "NEW" sheet in cells A1, A2 &A3.

I would like to copy the data from NEW sheet to OLD sheet, but only copy to
the visible cells., ie the results be copied on cells A1, A3 & A5.

It would be like the reversal of the Goto Visible cells/copy/paste from
Sheet OLD to sheet NEW.

Thanks for your help.

André
 
F

Frank Kabel

Hi
after selecting the range try the following:
- hit F5 and click 'Special'
- choose 'Only visible cells'
- copy the data
- paste the data in your target range
 
A

Andre Croteau

Hi Frank,

The procedure you are describing is what I did in the first place.
What I want to do now is the reverse. I want to copy cells A1, A2 & A3 from
the NEW sheet, back into the filtered list in the OLD sheet.

Is that possible?

André
 
Top