inventory

I have 2 sheets: one with Inventory for a day (8/30) and another with sales for the month with dates as 9/4, 9/7. etc. I would like to merge the two sheets so I can have a running total of inventory by taking the Inventory as of 8/30 and subtracting each day of sale invoices. I would then...

Today I use this function to calculate months of coverage =coverage(Cell that holds inventory, range of cells that have the monthly forecast) =coverage(F7,G5:I5) I want to use a function that does the same thing, but with value in the function such as : =coverage(1000,500,250,150,50)...

Hello! Right now I have an inventory list that has a macro in it where you can manually add parts onto a reserve so that other people will not use them. Basically you just type in the quantity and the part number and it will look up the part number within the inventory and add whatever quantity...

Before withdraw on inventory monitoring page: <tbody> A B C D 1 Part Number Start Stock Qty In Stock Balance 2 123 10 8 3 456 20 7 4 789 30 6 5 101 40 5 </tbody> Withdrawing on inventory withdrawal page(different tab): <tbody> A B C D E 1 Date Withdraw Part Number Withdraw Qty...

Hello, I am not sure if I can use a formula or a VBA code to do this task. <colgroup><col width="64" style="width: 48pt;"> <col width="325" style="width: 244pt; mso-width-source: userset; mso-width-alt: 11885;"> <col width="287" style="width: 215pt; mso-width-source: userset; mso-width-alt...

Hi Please excuse me if this topic has arisen before. I did do a search but did not see anything to assist me so far. I have a small restaurant and retail gift shop under the same roof. Keeping accurate inventory/stock control of the retail side is fairly straight forward even though at present...

I have another one for you. I have an inventory sheet I get from a vendor every week. All I need are the columns: Product Code QTY in Stock I would love for them to pull from all 5 sheets and make them one long list. I can't remember how do to that in PowerQuery. I get an updated inventory...

dear excel gurus, I am a low-middle level excel user, and i stumbled upon the following task that I seem cannot solve myself. There is an excel downloaded from a server that always adds new items, so, however, it is alphabetical order, every new sheet the lines can be shifted. It is an...

I am trying to create an order form, by which I want the customer to tick-off items they want from a long inventory. I want the checked items to be copied onto another new worksheet, which would be an order, or packing list. It would likely involve making check boxes to go next to each...

Hi all, its great to be apart of a good excel community now. I am about to pull my hair out on this one. I have been researching forever on what to do. I am trying to make an inventory spreadsheet of some toy figurines that I have and each time i click on a drop down to narrow down the next drop...

I have the following code that updates my inventory sheet with new totals. The problem is, when I enter something in that does not show up on the inventory sheet, I get an error message and when I debug, it points to the section of code shown below. My question is how to add an if statement to...

I am truing to use filter in specific order, first filter out all sub accounts to 100 and than find max year_dt, can someone please help me with the expression? Thanks Z Calculations:=CALCULATE( SUM(Inv2018T[Custom]), FILTER(...

Hi, I have written an excel macro, see below... it works fine for one single cell, but I need it to work down a column range of say 80 to 100 cells and can"t figure out how to make it go down the column. I have tried a loop, but all I was able to do was to compare M7 with the rest of the...

Hi, I have written an excel macro, see below... it works fine for one single cell, but I need it to work down a column range of say 80 to 100 cells and can"t figure out how to make it go down the column. I have tried a loop, but all I was able to do was to compare M7 with the rest of the...

What is the easiest way to sum all "GL No" from 1000-1099 in range A2:D9 relating to cash in Table 1 and place total into cell A2 in Table 2? ...2200-2299 in "Inventory" on Table 2 and 5000-5099 in "Payable" on Table 2 . I have created a helper column but there must be a better way.....any...

Hello All, Thanks for reading and any help I may receive.. I have a workbook that acts as a material form. I also have an Inventory workbook for all the materials we consume on a regular basis. I need help with a macro that will read from my Charge Out Template.xlsm workbook, from worksheet...

Hi everyone, I have a problem with a excel sheet, I am using both for inventory purposes. I download the new inventory and have to input the new value so that the shop will have the right inventory count. The problem is that the formula is not recognizing the value from the new sheet. Even...

Hello, I am looking to create a formula to update a rolling inventory need. please see below - thanks for the help! Need formula for E/F/G BELOW: <tbody> A B C D e f g 1 Current Inventory Monday sale Tuesday Sale Wednesday Sale Inventory need Monday Inventory need Inventory...

Hi, I need help figuring out the formula for the following case, I need to keep track of my inventory so I have a base inventory to wich I need to add the quantity of what is produced in a day and substract the amount of what is sold that same day. Inventory table <tbody> Code Name Qty On...

Apologies as I am new to the forums and am already coming in asking questions. With that being said, I looked around in an effort to find a scanning macro for Excel through VBA that met my needs. However, through searching I could not find something that had the functionality that I was looking...