copy only cells with data; don't overwrite existing with blanks
Posted on 2011-10-26
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!