kit

  1. D

    How many kits available with a component that occurs in multiple kits.

    Hi I found this tutorial very https://www.mrexcel.com/excel-tips/how-many-kits-available/ helpful. It has solved my issue to some extent. I am trying to create a stock and inventory management sheet. We sell one main kit and then an add on kit which comes in 8 different types. There are a few...
  2. R

    Collating data vertically not horizontally

    Afternoon All, Thank you in advance, i need help in presenting my data vertically and not horizontally. Fig1 is how my data is at the moment, however i need to present it like Fig2. Fig1 <colgroup><col><col><col><col><col></colgroup><tbody> KNr Driveshaft CV Joint Boot Kit Hub Nuts 10447...
  3. R

    Total Item Count

    I want to match "Order IDs" and add the "sku items" for a total kit count. Thoughts? Thanks R. Turner
  4. M

    Table to use multiple other tables

    Hello there everyone! So I'm in process of creating a new database for use at work that will manage and keep track of our tooling kits. i have a pretty good idea on what tables I'll need and how they're connected except for one thing. basically the main table i want is my kitting table...
  5. B

    Copy & Paste Values in Single Cells to Merged Cells via VBA

    <tbody> A B C D E F G H I J 1 Kit P/N Kit S/N Kit Part Kit Parts S/N Kit P/N Kit S/N 2 Kit 1 123 Part 1 001 Kit 1 123 3 Part 2 002 Kit 2 456 4 Part 3 003 Kit 3 789 5 Kit 2 456 Part 1 004 6 Part 2 005 7...
  6. B

    Excel VBA to Copy and Paste by Looking Up Values

    <tbody> A B 1 Item Number (Kit) Qty 2 Kit 456 3 3 Kit 123 1 4 Kit 789 2 SHEET 1 A B 1 Item Number (Kit) Parts within kit 2 Kit 123 Part 1 3 Part 2 4 Kit 456 Part 1 5 Part 2 6 Kit 789 Part 1 7 Part 2 8 Part 3...
  7. R

    Getting a PivotChart to report all weeks

    I've got a list of samples and would like to chart them, summarized by week number. Some weeks have 0 samples, some weeks have multiple samples. When I create a PivotChart, I can group it to summarize by weeks; however, it only displays weeks with samples and omits weeks with 0 samples. To the...
  8. T

    Counting unique values with multiple criteria

    Dear Forum Members, I would like to build a formula that would count Consultant IDs (only once, as they repeat) of consultants with Start Month "04" and the kit "S" (so in my below example the result is 1). <tbody> Consultant ID Start month Kit <tbody> 100731 </tbody> 03 S 100732 04 F...
  9. S

    UDF - How to write a CONTAINS function in VBA

    Experts, I need you... I have no idea what I'm doing here. Sheet1 Column A = Production # Sheet 2 Column B = Kit # Sheet2 Column A = Production # Sheet2 Column B = Kit # (multiple values in single cell) I need to lookup the production # in sheet 1, match it against the production # in sheet2...
  10. M

    Require a way to create if statement for images

    ok so my problem is that i currently have two rows of images, one for home kits and one for away kit images for a football database i entered. this being my current formula to pull the image dependent on the match that is requested by the user...
  11. B

    Macro to Search in Multiple Folders / Open / Copy&Paste all info into single workbook

    Hiya all!!! I suspect this is a challenge, even for the highest of highest excel / VBA gurus, however worth a try!!! I will try to explain. I want to create a workbook in the following location ( work network folder ) K:\Materials to keep\Stores\Trial and Service Kit Builds\ALL CURRENT KIT...
  12. B

    Kit breakdown - how many eaches are sold each week

    Hello. I have a list of items the name of which corresponds to multiple other items since they are in a kit. So for example, if you have 5 KITS, you really have 4 of this item, 5 of this item and 3 of this item. I have each step broken down in an ENORMOUS worksheet and there has to be an easier...

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