Merging over hidden rows

V

Velson Horie

I am trying to merge two spreadsheets with some (but not all) common rows. I
have therefore hidden the non-common rows in each of the two sheets in order
to copy and merge data only the common rows. Although it is possible to
choose to copy FROM only visible rows. it is not possible to copy TO only
visible rows. Or am I missing something?
Is there another way of doing this?
 
G

Gord Dibben

As you have noticed, you can't paste onto hidden rows or columns.

"Not same size" error message.

I would copy all sheet1 to sheet2 then use Data>Filter>Advanced filter to
find unique records only and copy those visible cells to a new sheet.

Or you could copy/paste to below all data on the same sheet then delete
original data.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Merging from an Excel file with graphics 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Copy/Paste with Hidden Rows/Columns Excel 2007 3
copying one column with hidden/filtered rows to another colum 2
vlookup with numeric and alphanumeric identifiers in lookup_value 1
opening a group but keep hidden rows hidden 0
Hiding Rows of Filtered Data 0

Top