# quantity

1. ### Looking up transaction table against pricelist with quantity breaks

Hi all, first time poster so hoping someone can assist! I have two tables: a table of transactions and a pricing table for both June and September. We're trying to establish whether the price since June has increased enough to cover additional costs (from Brexit price rises). So if Customer...
2. ### Sum values in one column until values in another column reach a certain value

I need to get the sum of the prices when the contract is ZS but need the sum per quantity of 10. So in this example, i need to find the sum of first 4 columns because that will make the quantity add up to 10. The problem is, i copy and paste in sets of data where the "ZS" contract will fill at a...
3. ### Quantity x Price = Line Total Invoice Problem

Hi, I'm clearly not very smart when it comes to Excel. I can't seem to figure out how to add an equation in my invoice for Quantity x Price = Line Total without all of the Line Total column with \$0.00 in it. Is there any way that that column can be blank until numbers are added to Quantity and...
4. ### Find identical value of cell thru all sheets. Sum the value to the left of that cell.

Hello. I have a master Bill Of Material sheet that I use to make BOMs, as options change for the order I delete sheets for those options not used. Each BOM will have far less data then the master, and some cells will change based on the needs of that particular job. The BOM has multiple part...
5. ### Sum array (or something) based on multiple criteria

Hi, Have a big problem - don't know If its possible to solve it with VBA. If the socialsec, date, fruit is same then save it into a temp or something sum quantity and print out as 1 line else different rows. Have a sheet with following data: SocialSec Date Fruit...
6. ### How many values between other values (count number cells between two of the same text)

Thank you for taking the time to look at my question. I have a production query that returns several columns of production data; see the example below: <tbody> Scan Date Operation Type Product Code Machine # Workpost # Barcode Serial Number 09/19/2014 23:49 CA CARCJ80S2586 S2 F01...
7. ### Calculate grand total from multiple rows of quantity and price/unit

Hello everyone, I would like to calculate and present the grand total, starting from a fixed range of two columns (each 10 rows), where one has quantities, and the other has the price/unit. Since I'm not allowed to change the layout of the sheet (it's a fixed template layout...), I can not add...
8. ### Help adding quantity to a Data Entry Excel/VBA

Hey all, First thanks in advance for all the help SHORT VERESION: I've created (from contextures "partsdata" http://www.contextures.com/xlForm02.html) my own form which has a data entry sheet which I need to add a quantity to (EXCEL LOCATED THERE...
9. ### simple percentage increase to the quantity in VB

Hi guys, Can anyone help me with this ?? My original VB code is ElseIf brand = "MAC" And year = "2013" Then Profit = 22 / 100 * cost * quantity ElseIf brand = "Rimmel LONDON" And year = "2013" Then Profit = 31 / 100 * cost * quantity ElseIf brand = "REVLON" And year = "2013" Then Profit...
10. ### Conditional Formulas - How do I make quantity of a cell change the value of other cells?

Hi, I'm really new to this spreadsheet stuff and I can't seem to find a simple answer to this question... How do I make a cell change to another cell's value based on the value of a third cell? That's a confusing way to ask, perhaps. I have quantities (1-12) and different dollar amounts for...
11. ### Multi-quantity inventory with scanner

Hey all, I am pretty new here. I looked at a few of the threads related to inventory but none would do what I want to do. Basically, I want to scan a box that will have shirts in it. The box will have a barcode with the item number on it and then a barcode with the quantity. I was hoping to...
12. ### Excel formula - Pricing based on quantity

I am creating a purchasing form in Excel 2003, Windows XP. The items have a sliding scale for pricing (the more you buy, the cheaper they are). So the Quantity price (N10) in the formula effects the total price. I have three different pricing amounts and can only get two to work. How do I add in...
13. ### Repeating Lines

Hi, We are about to move into a new building and so have recently completed an audit of our existing equipment and furniture. Now that has been completed, we are needing to compare this with the list of what is required for the new building. The Audit sheet lists every item, by its item code...
14. ### Sum duplicated values and quantity

Hi everybody I am trying through whole weekend to create autocalculation for following spreadsheet. I want to count all duplicates in spreadsheet. <TABLE style="WIDTH: 330pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=439 border=0><COLGROUP><COL style="WIDTH: 48pt"...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...