quantity

Hi all I have list of details have dots at the end I want formula to remove all please help me in this. <colgroup><col width="153" style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595;"> <tbody> Match Type . . . . . . Address Number ( # ) . Mailing Name . . . ...

I have two excel sheets Sheet 1 <tbody> productID 18-5-2019 17-5-2019 16-5-2019 15-5-2019 for5 months.... <tbody> 32852314981 </tbody> =? = <tbody> 32796241751 </tbody> <tbody> 32918411783 </tbody> requirement <tbody> 32852314981 </tbody> 100 0 25...

Hi I have a packing list on an excel sheet with 2 columns. Column A contains a PartNumber, Column B contains a Quantity Number. So, e.g. column A "Widget", Column B "5" Meaning we received a quantity 5 of "widget" I want to print a separate label for each widget, any suggestions on how...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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