shortage

  1. J

    Optimize Index Lookup Formula?

    I have a formula which works, but I would like to see if it's as optimized as it could be. I've a new computer and it's either a LOT slower than my older one (very possible), or this forumla needs to be optimized with a better formula or moved to VBA. I am looking for the last instance of a...
  2. H

    Trying to understand index/match for specific scenario

    Hi, I seem to be able to use index/match for a specific scenario but struggling to apply it to others so looking for some help - maybe that's not even the best way of doing it. I have two data sources a list of products and another data source with the products, order despatch dates and...
  3. G

    VBA Help: input new value based on criteria

    Hello, I have a workbook that we are using at work to track material allocations to work orders. What it does is show the customer order, the material it is short on, the job that exists that could satisfy the shortage, the quantity remaining of that job to fulfill the shortage, and the next...
  4. B

    VBA to overwrite value from new formula result

    Hiya all, I have a workbook in which my staff are responsible for maintaining. At the start of each week I have a snapshot of the week ahead. I have 3 columns which I am particularly interested in which shows Open Stock / Shortage Current Week / Shortage next week. They are responsible for...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top