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

Posted on 2011-10-26
Last Modified: 2012-05-12
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!
Question by:wirbicki2
    LVL 10

    Accepted 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.

    Author Closing Comment

    Worked perfectly and exactly what I was looking for.  Thanks!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now