Forum Discussion
Paste TO visible cells only in a filtered cells only
I just tried the steps below and go the below error message:
What might I be doing wrong? Thanks.
DanNow The steps I described only work when you paste a single item into multiple cells. As the error message says, if you have several items selected, the target of the paste must be the same shape as the source.
In this case you may need to sort your source table so you can select the data as one contiguous range, then sort the target table and paste as one contiguous rang there, too.
- Its not working. kindly guide through video
If anyone still has problem with this, please check out this article:
https://www.mrexcel.com/board/threads/excel-vba-easy-way-to-paste-to-visible-cells.1239792/
it shows you how to make copy-paste visible cells functionality available in any open workbook.
Sajad_Alam If you are having issues, try my earlier post on the first page.
IngeborgHawighorst Thanks for responding. Yes, that is the difficulty; the target table was not easily sorted into one contiguous rang. That said, I just used some vlookups to help me transfer the data from the source file to the destination file. It is a shame that there isn't a way to inform Excel that the pasted data should only be deposited into visible cells. Have a good one.
