• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

copy only cells with data; don't overwrite existing with blanks

I have a master spreadsheet which was disseminated to several different people.  They have all updated different rows on their copy of the spreadsheet.  What I need to do is:

copy the data from column K of each person's copy of the spreadsheet on to the master.  If I do this for person A column K, when I do it again for person B column K:  it overwrites data with blanks.  (e.g. if person A filled out rows 1-20, and person B filled out rows 21-40, if I copy column K from person A and paste, and do it again with person B, I end up with blank rows on 1-20).  There isn't a way for me to sort & copy either.

I can put each user's copy of the master in Sheet2.  Both sheets have Account# in column A which is a unique identifier.

So how can I keep copying data from person A, B, C, D, etc to column K (to the correct row with account # on the master), without overwriting the previous with blanks?  Thanks!
1 Solution
Not quite sure what you are doing. If you Paste special, there is a toggle for Skipping Blank entries on the dialog. This may accomplish what you want.
wirbicki2Author Commented:
Worked perfectly and exactly what I was looking for.  Thanks!

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now