+ Reply to Thread
Results 1 to 4 of 4

AutoFill & Calendar

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2007
    Posts
    3

    AutoFill & Calendar

    Hello,

    I am trying to make an excel document that takes the information inputed in one sheet (Library) and inputs that information into another (Calendar) type sheet according to some conditions.

    I would like the information inputed in the Library sheet to appear in certain cells of the Calendar sheet if the day of the week corresponds and if the date of the cell is greater than the start date and less than the end date (information inputted in the Library sheet). I would like to create code for the document to read the date information as a date.

    I have made the calendar to have four cell below a cell that states the date. I would like the information in the Library sheet to auto fill into these cells until those cells are filled.

    Thank you for your help!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,351

    Re: AutoFill & Calendar

    It would be best to supply a sample workbook.
    Click Go Advanced, then the paperclip to upload a sample workbook

  3. #3
    Registered User
    Join Date
    04-02-2012
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: AutoFill & Calendar

    Here is what I've created so far. Thank you
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-02-2012
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: AutoFill & Calendar

    I've attached the sample document.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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