Copy to visible cell after Autofilter
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.
"Hank" wrote:
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
|