+ Reply to Thread
Results 1 to 3 of 3

Drop down boxes with months shown that change all the data

  1. #1
    Registered User
    Join Date
    05-13-2014
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Drop down boxes with months shown that change all the data

    I have set up a sheet recording an each individual’s turnover for my business ie, hours worked, etc and have set up a data validation table for drop down options of Jan, Feb, Mar,etc....
    Rather than creating more work for each month on the worksheet, how can I enable the drop down to contain the data specific to each month?

    Thanks Nick

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Drop down boxes with months shown that change all the data

    Hi there,
    pls 'Go Advanced' and attach sample workbook.

    Regards

    M

  3. #3
    Registered User
    Join Date
    05-13-2014
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Drop down boxes with months shown that change all the data

    To be able to post Visitor messages your post count must be 5 or greater. You currently have 1 posts.

+ 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. Replies: 9
    Last Post: 10-25-2013, 12:13 AM
  2. Horizontal Data Filtering - Drop down boxes
    By barqujo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-07-2013, 12:26 PM
  3. Trying to use drop down boxes to apply data
    By aweciti in forum Excel General
    Replies: 1
    Last Post: 11-03-2012, 10:41 AM
  4. Adding drop boxes to cells with data
    By johnlovesbeer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2009, 03:11 AM
  5. [SOLVED] advanced: synchronizing data value across two worksheet drop boxes
    By mdhokie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 04:05 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