item#

  1. Knockoutpie

    How do I take a total value and reduce the value of a cell and move to next until the total is met?

    It's difficult to describe, but could be considered something like a first in first out calculator. There must be an easier way to do this than manual subtraction. For this example the total inventory is 7500, I Would like to find how much was under 25, and if the total isn't met then move to...
  2. D

    VBA Loop through column, count multiple different values and output total of each in a cell

    Hello, I'm quite awful at VBA and am trying to make a macro that does this: <tbody> E F G H I Item# Item Name Qty Total Tracking 1000 xxxx 2 xxxx 1000 xxxx 1 3 xxxx 2000 xxxx 1 1 xxxx </tbody> For this format, with the letters on top being default excel columns, I am trying to have...
  3. L

    Combining Data Sets

    I have two sets of data which have a common field but also a unique item which I would like to combine into one data set. EG. Branch A has: Branch B has: Item# Qty Item # Qty 1 2 1 3 2 5...
  4. S

    Dynamic Filtering

    Hi, I wanted to know if excel support a feature where if I filter a selection on sheet, the selection carries over to the other sheets in the same workbook. I am working with excel 2010. For example if I filter to a specific Item#, the other sheets will filter to that Item# as well. If its...
  5. F

    Sorting Data With VBA. Possibly With Vlookup?

    I have built a tool on a different sheet, and it basically fills out 5 rows and 3 columns of data. What the tool does doesn't really pertain to anything I need to do, but I'd like to have a way to send the data that I use with the tool to another sheet in the workbook. So data in C13:E17 is the...

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