Forum Discussion
Paste TO visible cells only in a filtered cells only
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.
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.