Results 1 to 14 of 14

Populate Table with data from other sheets based on drop down selection

Threaded View

  1. #9
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Populate Table with data from other sheets based on drop down selection

    I'm sorry...I did not know that you responded to my last message. I'm not sure where or how to mark the case solved. I'd appreciate it if you could show me. However, I have one "formula" concern which i hope to get assistance from you. On Sheet 5 of the attached behavior monitoring file, on cell M8, I wanted that cell to display the formula value of C8. However, I wanted the cell to display "NA" if the date on B8 is a saturday or sunday. As you will see, the cells from B6 to V36 gets greyed out if the date on the B column falls on a Saturday or Sunday.

    English2 Behavior Monitoring Modified.xlsm
    Last edited by nhen.enry; 09-05-2012 at 11:54 PM.

Thread Information

Users Browsing this Thread

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

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