I have two spreadsheets, one of them is a list of events taking place this year and one is a calendar that has a row for all 365 days per year.

I had put the event names in to the calendar and then filtered that sheet so that only rows with event titles entered are visible using the dropdown on the header row.

I now want to copy and paste the rest of the event information over in batch without having to do it line by line and so selected the appropriate column and used Find & Select-> Go to Special...->Selected Visible Cells only but when I then try to paste to those visible cells I get the error message:

"You can't paste this here because the Copy area and paste area aren't the same size. Select just one cell in the paste area or an area that's the same size, and try pasting again."

I've checked that I'm copying 230 rows and I've selected 230 rows, I've even tried resizing the cells so they're the same dimensions but I just get the same error every time. If I only select one cell then it pastes the data in to the invisible cells as well.

I've tried googling the error message but not found a solution that works so any help will be much appreictaed.