+ Reply to Thread
Results 1 to 13 of 13

How to fill only blank cells based on another worksheet

  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    USA
    MS-Off Ver
    Office365
    Posts
    32

    How to fill only blank cells based on another worksheet

    Dear excel heros,
    I have a question here best described in the attached png file.example.png
    From the example I have attached, what i want is to fill blank cells of table A automatically (all red Ts) based on Table B

    And any change of dates in Table B should reflect in Table A with "T". Any help on this will be much appreciated.

    with many thanks and best regards,
    Prad

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: How to fill only blank cells based on another worksheet

    Plz see the attachment, if that is what you wanted
    Attached Files Attached Files
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

  3. #3
    Registered User
    Join Date
    12-12-2012
    Location
    USA
    MS-Off Ver
    Office365
    Posts
    32

    Re: How to fill only blank cells based on another worksheet

    Awesome!!! Rajesh ji you just got in to the crux of my problem and understood it more than me. Thank you soooo much for your help ....very much appreciated.

    best,
    Prad

  4. #4
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: How to fill only blank cells based on another worksheet

    Glade it help you, Thanks

  5. #5
    Registered User
    Join Date
    12-12-2012
    Location
    USA
    MS-Off Ver
    Office365
    Posts
    32

    Re: How to fill only blank cells based on another worksheet

    Rajesh ji,
    I have one more question on the same. Please see the attached png and purple highlighted cells where "a" is appearing twice with different dates. How to get complete dates that staff "a" is travelling. your help on this will be much appreciated. meprad.png

    with many thanks
    meprad

  6. #6
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: How to fill only blank cells based on another worksheet

    I m working in your file but just not getting the right formula. Any person may appear any no of times

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: How to fill only blank cells based on another worksheet

    Instead of pictures please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

  8. #8
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: How to fill only blank cells based on another worksheet

    I have taken minimum & maximum dates as the reference.

    Please try this file.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  9. #9
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: How to fill only blank cells based on another worksheet

    Hi ramanan,
    I tried the same thing it is ok for the given example.
    But say if "a" travel from 01-08-2013 to 02-08-2013 and from 04-08-2013 to 05-08-2013, then the issue arises.
    dated 03-08-2013 should be "L" instead of "T".
    How can we point out that gap date

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: How to fill only blank cells based on another worksheet

    With reference to attachment file posted by ramananhrm in Post #8, try the below formula

    In D7 Cell

    =IF(COUNTIF($J$6:$J$9,$C7),IF(SUMPRODUCT(($J$6:$J$9=$C7)*(D$6>=$K$6:$K$9)*(D$6<=$L$6:$L$9)),"T","L"),"")

    Drag it down and right....

  11. #11
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: How to fill only blank cells based on another worksheet

    Thank U sixthsence that worked fine.

  12. #12
    Registered User
    Join Date
    12-12-2012
    Location
    USA
    MS-Off Ver
    Office365
    Posts
    32

    Re: How to fill only blank cells based on another worksheet

    This is what I wanted !!! ....Thank you Sixthsense for your generous help...and thank you Rajesh ji for making it possible through your deliberate help.

    regards,
    meprad

  13. #13
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: How to fill only blank cells based on another worksheet

    Glad it helps you and thanks for the feedback and rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto fill worksheet cells based on certain criteria w/out leaving blank rows.
    By Txprospector in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2014, 07:35 AM
  2. Fill blank cells with data directly above that blank cell
    By gibson2503 in forum Excel General
    Replies: 3
    Last Post: 06-05-2013, 10:07 AM
  3. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  4. [SOLVED] Search and fill blank cells based on various conditions
    By johnny_tc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2012, 09:40 AM
  5. Replies: 0
    Last Post: 04-07-2009, 04:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1