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
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
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
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
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....
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
--
Dave Peterson
That helps. Thanks Dave a lot for the solution.
Hank
"Dave Peterson" wrote:
> 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....
>
> 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
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks