Results 1 to 10 of 11

Thread: Select Sheets For Specific Date By Clicking On A Calendar

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    To your previous question, no it's not more prone to error than any other solution one can think of, but it's just that it is easy for a user to identify and relate to a button on an index sheet, rather than a date on a calendar. But of course that depends on who the user is. So if the above works for you, I'm fine with that.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  2. #2
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    13
    Hi

    The Calender set up work great Thank You

    Is there a way i can quickly add a years worth of sheets for mondays and wednesdays for a given year copying all the data from a template sheet puting the correct date name on the tabs so that the calender will find them (i have manually put 2014 on the workbook but its very time consuming)

    Thank you for your help so far

Similar Threads

  1. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  2. Replies: 3
    Last Post: 06-10-2013, 06:12 PM
  3. Replies: 4
    Last Post: 06-10-2013, 01:27 PM
  4. Replies: 3
    Last Post: 05-17-2013, 01:22 PM
  5. Replies: 0
    Last Post: 02-27-2012, 01:07 AM

Posting Permissions

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