Hi everyone I need help with Merging my spreadsheets. I can't get it to work the way I need it to. I am uploading two Sample spreadsheets to illustrate what I am trying to do. If you look at testmaster1 there are a few blanks, testmaster2 has the spots filled in. How can I merge the two spreadsheets so that it will fill in the blanks of Testmaster1 with the information in testmaster2 without it overwriting the cells that have text? My End result should be the two spreadsheets merged with no blanks, and the blank cells filled with the information from testmaster1. Thanks in advance for anyone who can help!
Testmaster2.xlsTestmaster1.xls
