+ Reply to Thread
Results 1 to 2 of 2

Need additional Years Added to Calendar Linked Spreadsheet

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need additional Years Added to Calendar Linked Spreadsheet

    First off, I would like to say thank you to Pete_UK! I came across your calendar spreadsheet a few years ago (ef66_calendar_multi_lookup.xls‎) and it has been extremely useful to me for work purposes.

    We are coming up on the last year that the calendar supports in the document and I was wondering how to add more years(Calendar tab, Cell K4)?

    Thank you in advance!

    Marc Z.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Need additional Years Added to Calendar Linked Spreadsheet

    Click the cell. Go to Data --> Validation --> In the Source box add: ,2016 to the end of it.

+ 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. Additional Field Added after Macro is Run
    By kelz_dunks4life in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2014, 05:18 PM
  2. [SOLVED] How to apply macro to a range, even if additional rows are added
    By Lowa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-11-2014, 01:00 AM
  3. Replies: 2
    Last Post: 04-01-2014, 09:24 PM
  4. Counting additional entries on a linked Spreadsheet
    By Gooford in forum Excel General
    Replies: 5
    Last Post: 09-29-2009, 08:14 AM
  5. [SOLVED] Apply fomulas to additional worksheets as added
    By Brent E in forum Excel General
    Replies: 2
    Last Post: 05-25-2006, 04:40 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