commodity

  1. A

    Assistance Creating various sheets for analysis involving constantly updated data from Master sheet.

    I have over 1000 rows, and it continues to grow. I wanted to know how to create charts that will update as more data is inputted to master sheet. ie) Commodity & Approx. Sales Table - 5 different commodities and each transaction $ worth. I need help getting each specific commodity sales $...
  2. gheyman

    Formula that calculates using Inflation factors

    I have a commodity code in column A. then in Columns B through M I have inflation factors for each year starting in 2016 (B has an inflation factor of 2.177%, C 2017=3.419%, D 2018=.03360, E 2019=.02415, F 2020=.02701, G 2021=.0241,H 2022=.02860 and so on (Row 1 has the year Row two has the...
  3. C

    Populate template with macro

    I have a worksheet with MULTIPLE TABS that are in the exact same format for different Subcategory/Commodity names (the tab names). I need to take each of the tabs and populate the corresponding columns on the TEMPLATE. Note: The following are the Tabs to Template column matching (since some of...
  4. C

    Create new supplier rows based on subcategory/category levels

    The purpose is to identify EVERY possible missed commodity code a supplier should have been mapped to that falls under CATEGORY or SUBCATEGORY level. Ideally the script will only add the ones that are missing, but if it is easier to dump ALL COMMODITIES that are under the Subcategory that will...
  5. C

    Data rows with multiple vlookup values

    My problem is in 2 parts. Each supplier listed in the tab "IT App Dev" (Column B) needs to be matched with a Commodity Code. The Commodity Code is determined by VLOOKUP the SubCategory Code "IT App Dev" (Column K) in the tab "Phase 2 Taxonomy". For this SubCategory there are two (2) commodity...
  6. B

    Invalid Procedure Call - Trying to join using Mid and Instr

    tblA has commodities such as ME Milled Rice, and tblB has just ME and second field with load factor =Mid(tblA.Commodity, 1, InStr(1, " ", tblA.Commodity) - 1) = tblB.Commodity <tbody> tblA field1 field2 Commodity abc 123 MR - Milled Rice tblB Commodity LF MR 22 </tbody>
  7. J

    Calculating Commodity Sell Prices based on Market Changes

    I have a project that I am trying to work on for the owner of a contracting business and have some confusion on how to work this out. I work with electrical contractors to buy wire... The price of these products are directly related to the market. However, the only thing I have to start with...

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