part number

  1. M

    Need a macro to conduct some steps for each part number in a column

    I have an Excel sheet with 12 columns and 4000+ rows. In Column E, I have a list of part numbers. These part numbers may or may not be repeated based on the city names found in Column F. For example, Part A (located in Column E) may be in 3 different rows: one row for City X, one row for City Y...
  2. Y

    VBA Find Part Number and highest Serial Number and add 1 to last row

    I am having trouble coming up with a VBA code to find a part number I am searching for and then finding the highest (or last row) serial number, adding 1 to that number and creating a new line item. <tbody> Part Number Serial Number Description 5462H 023 Pan Head Screw 6524X 018 Washer...
  3. A

    Using the MIN IF Function

    Hi! I'm not an excel newbie but just learning all about the different functions that can make my job a lot easier.. In the spreadsheet I'm working on I know I need to use a MIN IF formula but I cant seem to get it to work. I have a list of Part Numbers in Column A, repeated multiple times...
  4. E

    Style number / part number auto-populate in 2nd table

    I am a novice in excel (2010). I own a t-shirt brand, when I put together a print run with multiple designs, that have multiple colored shirts per design (as shown in my screenshot). I need to then total up the number of: SMALL BLACK-T, MEDIUM BLACK-T, SMALL BLUE-T, ETC from all designs...
  5. C

    Drop down list with a different output than input

    Hi all - I am wondering if there is a way to create a dropdown list that outputs a different value than what the input was. For example, I want the dropdown list to contain full words (Machined, Bought, Assembled ect...) and when you click those words, it outputs a code based on the word (M, B...
  6. R

    Part Number Sorting..... Help :)

    I have tried everything I can think of to accomplish this sort. At this time I have spent more time trying to figure out the sorting of my document than it would have taken to re type it. Here is my problem: I have part numbers that are either solid numbers or alphanumeric. When Excel...

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
Top