inventory

Hello all! This is my first time posting so please forgive the lack of detail. . . I am trying to create a table with a summary of items that need to be Restocked across 4 different sheets. I am relatively new to Excel and while I've been able to puzzle other issues out thanks to the help I've...

Everything I input into Solver is giving me a not feasible solution. How should I be setting up a linear regression to find optimal production with the following data? I'm also unsure of how to add a promotion, any tips? <colgroup><col width="157" style="width: 118pt;"><col width="65"...

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