Results 1 to 17 of 17

Format control data - values to be input differently on different tabs

Threaded View

  1. #15
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,848

    Re: Format control data - values to be input differently on different tabs

    Yes, the array entered formula* that populates the 'Name' column is:
    Formula: copy to clipboard
    =IFERROR(INDEX('Holiday Sheet'!$A$3:$A$16, MATCH(0, IF(MONTH('Holiday Sheet'!$B$3:$B$16)<>4, 1, COUNTIF(A$1:A1,'Holiday Sheet'!$A$3:$A$16)), 0)),"")
    The formula that populates the 'Holidays' column remains pretty much the same.
    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let us know if you have any questions.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code working only for a standard input. If input changes then code behaves differently
    By DhanyaTeacher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2018, 12:41 AM
  2. Checkbox using Format Control and copying control values
    By bigapple14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2014, 09:28 AM
  3. How to control cursor with variable input values
    By Petrocelli99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2014, 02:01 PM
  4. Is there a way to have row data move between tabs but input in a new order?
    By Alexander.Tartter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2013, 12:58 PM
  5. Control Autofilter Tabs with Data Validation list box Value
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2010, 10:15 AM
  6. Input to Master and Have Multiple Slaves Each Sort That Data Differently
    By AmeriKen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2009, 10:07 AM
  7. Copy input range and paste into Format Control
    By Tibby in forum Excel General
    Replies: 2
    Last Post: 10-28-2008, 04:39 PM

Tags for this Thread

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