Lookup Values, Calculate Ouputs...

  • [SIZE=14px]I would like some help in looking at writing some VBA to work out Outputs against dates.[/SIZE]


    What I am trying to achieve is to be able to write some VBA to to allow me to workout what my output of types of goods will be, by taken an Input number on a given day and times that by a failure rate and project the date forward by the numbers of days taken to delivery the goods.


    I have an Input Table for the Types of Goods and their sub types, Delivery Assumpions Table with Days to Deliver and Failure Rates and a Output Table.


    I need to match the Goods Type and Sub Types in Both Goods Input and Delivery Assumptions Tables.
    …I have a Input number (B5) and want to times that by a failure rate (B19), (10*.90) = 9
    ...then return that number in a cell (J9) with a date (I17)
    ...that is a date in the future which is a derived date from the date (A5) (01/04201) + the days in the Days Cell (B18) (11/04/2018)


    please see attached the .xls sheet and a screenshot...



    https://1drv.ms/f/s!AkTnzpwBhp_niWOQ0_GC008Rtzf3



    [SIZE=14px]Many Regards, Paul[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!