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

Hank

"JLatham" wrote:

> 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