Bored at work? Make some nuz...
DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)
Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact | Forum

| 
Data Worker Exchange
 » 
DigDB Users

Please Help with Merging and Filling in the blanks

View: New views
1 Messages — Rating Filter:   Alert me  

Please Help with Merging and Filling in the blanks

by bdogg27 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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.xls
Testmaster1.xls
Free Forum Powered by Nabble Forum Help

Features | Testimonial | Download | Purchase | FAQ | License | Contact | Forum (powered by Nabble's free forum)

Copyright © 2006 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.