# quantity

1. ### ListBox for Specific Condition

Hellow to everyone. Please help me. I have this Range("A2:D4") with fruits and quantity To load this Range in a Listbox Userform i use this code Private Sub UserForm_Initialize() ListBox1.RowSource = Sheets("Sheet1").Range("A2:D4").Address End Sub I want to know which is the vba code to...
2. ### Tricky Unique ID

Hello, hope you guys can hep me with this problem. Below is an example of what my file looks like. I would like to create a unique ID in column A by concatenating the Types in column C and the Product ID also in column C above each table. So for Product A, the expected result in column A...
3. ### Sequential Calculations

Hi, I'm have a large data set and am trying to identify a formula that will make a calculation based on the sequence number. Example below. From a lookup I have identified that a quantity of 3 are packed, but I want the 3 to be deducted from the first schedule line only, and if the schedule...
4. ### Need Help With Accounting System

Hello everyone, I'm creating an accounting system that includes invoice recording and an inventory system. And I need help finding an automatic way to calculate the inventory stock. Example: Page 1: Contains Invoices Product X | 35\$ | 5 Name.....Cash Paid....Quantity Purcahsed. Page 2...

I've inherited an Excel document that is used to keep track of where materials are located within out facility. Recently they asked me to include quantity counts and mark them red when quantity gets low. This part wasn't hard, simply used a <count-if> function, then set conditional formatting...
6. ### Pivot table view setting Dollar Amount and Counts in alternating columns vs grouped

I have a pivot table and have the total amount in dollars, and the total quantity in the Values. This displays the data like this Row 1 Amount | Quantity Amount | Quantity Amount | Quantity Amount | Quantity so for each month there is an Amount and Quantity. I need to display the pivot...
7. ### MAXIF on dates

I searched through the many MAXIF posts and can not find a solution to my problem. Lets say I have a two column list, first column is date and second column is quantity. What I am looking for if the maximum value from a particular year. I tried =MAX(IF(YEAR(A2:A12)=2017,B2:B12)) but it returns...
8. ### Worksheet_Change Inquiry

Hi, I'm a beginner in VBA and I'm not familiar with most of the code here. I read up on several threads about Worksheet_Change() and can't find something that suits to my need. Currently, I'm doing a project and let's assume that I changed the price of fish from \$2 to \$4. Sheet 1 (Original...
9. ### VBA to copy rows to a master sheet when a quantity is entered in one of the material worksheets

I have attached my file. I have tried several different codes, but to no avail. Upon entry of a quantity in worksheets Conduit, Strut, Wire & Misc., I need that row of information to be copied into the RFQ form in the respective columns. I have deleted all the codes that I have tried so I am...
10. ### rounding error

Hi, i'm facing an issue with rounding error and i would like to know if there is a way to solve it. below is an simple example. <colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align...
11. ### Filtering an array based on month.

I have 3 different areas of a worksheet allowing data entry or doing calculations. The first area is cell rang C7:F7. C7 is a date entry field, D7 is a size entry field. I.e. 6m,6W,…… E7 is a quantity entry field. F7 is populated with this formula...
12. ### Power Query - Split an amount into multiple rows

Hi I have a scenario where I need to be able to split the amount over multiple rows. Example of current data <tbody> Invoice number Location Quantity Amount 100 A 2 10 101 A 4 30 101 B 1 0 </tbody> What I need to do is against invoice 101 be able to split the total invoice amount...
13. ### Formula for %Difference w/ two error scenarios

I can't quite figure out the formula for the following scenario - We are looking at counts and adjustments so we want to see positive and negative % differences. The problem is if the book quantity is 0 and the count quantity is 0 and the book quantity is 0 and the count quantity is anything...
14. ### vba help

I have an issue on hand whereby the format of the data is not usable for pivot. Current format <tbody> Header 1 Header 2 Header 3 Header 4 Header 5 March 2018 Quantity March 2018 Value April 2018 Quantity April 2018 Value May 2018 Quantity May 2018 Value June 2018 Quantity June 2018 Value July...
15. ### Add 2 values that's criteria match.

<ytd-expander id="expander" class="style-scope ytd-comment-renderer" style="display: block; --ytd-expander-collapsed-height:80px;"><yt-formatted-string id="content-text" slot="content" split-lines="" class="style-scope ytd-comment-renderer" style="white-space: pre-wrap...
16. ### sum if-match quantity

Hi guys, I have this excel file that I don't know how to start or what to use function or necessarily for macro. I have input sheet, like below: When I input No. and quantity then it will sum to another sheet that match to the column that I inputted. So, once I input No. 1-A, then quantity to...
17. ### Pivot Table Formatting

Hi, I need a way of formatting cells by colour in my pivot table when the totals do not match. If you look at the example below John has a quantity of 10 while Sam has a quantity of 7. I'd like both numbers to appear red when this occurs. I'd also like the quantities to both turn green when they...
18. ### Need help

In cell E19 I have a drop down list which has Pears, Apples and Bananas. In cell E20 I have the finish quantity and in cell E21 I have the start quantity. My questions are these: 1. Is it possible to use the same cells E20 and E21 for Pears, Apples and Bananas which have different quantities...
19. ### Delete selective output from SUMIFS formula?

I am trying to get the sum quantity of the items both unique and duplicates but with only one output. I've attached my spreadsheet for review, but in case here is what I have. A B C ID Key Item Quantity Mickey wand 6 Minnie...
20. ### Excel like POS

Hi, I would like to build simple excel file to be like POS in small Market. Attached is my file. In sheet1 there is barcode, products, price, Quantity and so on..The idea is that in sheet2, to the column A will be intered products barcode from scanner, and the other dates(product name, price...

### 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...