Results 1 to 3 of 3

Auto fill variable dates

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2008
    Location
    Essex, England
    MS-Off Ver
    Office 2010
    Posts
    52

    Auto fill variable dates

    Hi,

    I have attached a copy of my workbook.

    What I would like to do is in I2:I9 on 'Leave Calculator' tab, have a formula in each cell that references B12 and then lists the 8 dates for that year from the 'BH dates' tab cell (B2:B9).

    I also want to do it for the Christmas ones but should be able to work that out from any help given on the above.

    Hope that makes sense!

    Any help greatly appreciated - thanks.
    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. Auto-fill Columns based on the value of variable
    By NeoDasari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2015, 08:37 PM
  2. [SOLVED] Auto fill dates
    By twrtleduck in forum Excel General
    Replies: 6
    Last Post: 09-09-2013, 03:59 PM
  3. [SOLVED] Auto Fill Formula to Variable Range.
    By Trevasaurus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-08-2013, 03:09 PM
  4. auto fill dates
    By pmbhome in forum Excel General
    Replies: 2
    Last Post: 06-25-2013, 08:49 AM
  5. [SOLVED] Another Auto Fill variable length column
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2006, 12:00 PM
  6. [SOLVED] Auto fill dates
    By Jennifer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2006, 03:50 PM
  7. RE: Auto fill dates
    By Jennifer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2006, 03:35 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