+ Reply to Thread
Results 1 to 2 of 2

Monthly parts ordering form, autopopulate based on calendar month and lead times

  1. #1
    Registered User
    Join Date
    12-22-2008
    Location
    Missouri
    Posts
    39

    Monthly parts ordering form, autopopulate based on calendar month and lead times

    Good morning,

    I have a workbook that I am creating that would show our parts that we order on a constant monthly basis (ie, filters, grease, bearings, etc)
    Each worksheet would be for a different month and would have the following column headers

    Item #
    Description
    Qty/Month
    Location
    Vendor
    Lead Time
    Date for next order
    Date Ordered


    The parts should always be expected to arrive by the first business day of the month (ie, Thur. November 1st) (we don't care to take account for holidays). I would like for the auto populating area under Date of next order to account of the days of that current month, the date that the parts need to be there, the amount of lead time the parts will take to get there, and has to account for variables such as lead time can only include business calendar days.

    So for example (in the October Sheet) the month of October has 31 days and there is a 2 day lead time on filters and they must arrive by Thurs. Nov. 1st, it should autopopulate to say the date of next order will be : Oct. 29th, 2012.

    But (in the November Sheet) the month of November has 30 days and there is a 5 day lead time on the filters and they need to arrive on Mon. Nov. 3rd it would then autopopulate to say the date of next order will be: Nov. 23rd, 2012.

    Is this possible?

    Thanks in advance.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Monthly parts ordering form, autopopulate based on calendar month and lead times

    Hi LadyDubs,

    Please upload a sample workbook... thanks.


    regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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