Copy to visible cell after Autofilter

[Guest]

Hi, I have a worksheet which have been AutoFilter, I need to copy data from
other worksheet to filtered visible cell, how can I do that to paste
correctly??

Thanks a lot.

Hank

 

[Guest]

I believe that if you'll go to the other sheet and just COPY the cell there,
then instead of a regular paste, click the destination cell and use

Edit | Paste Special
and make sure the option button next to [Values] is selected. This will
copy the actual value from the other sheet, not any formula or format or
anything like that.

 

[Dave Peterson]

Excel doesn't have any built-in support for this kind of pasting (to
non-contiguous cells).

Maybe you could sort your data first to make sure you're pasting into a
contiguous range--then sort it again in the order you want.

Or paste it visible area by visible area by visible area....

 

[Guest]

I want to paste to filted visible cell which is not pasted in right position.
Thanks

Hank

I believe that if you'll go to the other sheet and just COPY the cell there,
then instead of a regular paste, click the destination cell and use

Edit | Paste Special
and make sure the option button next to [Values] is selected. This will
copy the actual value from the other sheet, not any formula or format or
anything like that.

Hi, I have a worksheet which have been AutoFilter, I need to copy data from
other worksheet to filtered visible cell, how can I do that to paste
correctly??

Thanks a lot.

Hank

 

[Guest]

That helps. Thanks Dave a lot for the solution.

Hank