sku

I use the below script at work to easily and quickly concatenate large amounts of data. We use this to create a common denominator for vlookups between reports. I want to see if I can make this report as automated as possible. The script reads as follows: Sub combine_columns() Dim store As...

Hi all, I am trying to figure out the best way to incorporate an inventory reporting formula to state the "Inventory Level" of an item based on recent/all purchase orders. In Sheet 1 it will contain all inventory currently being held with key information such as SKU and Inventory Level of...

This is part of my formula. So it's a box I click on... I enter Supplier name, department, and information of the supplier first... and then eventually ITEM# or SKU# Now, what I added was in between END IF and END in RED. Because I didn't want to have duplicate item numbers in my system...

I'm trying to create a sumifs formula to determine the sales of a state for a certain sku in a timeframe. This is just a subset of the source data. I'll be looking for a few states, but Iowa to start. This info will be populated in another cell. Iowa for sku 2330993 and for this week 201711...

Hi Everyone, I would like to know if it's possible that is, on how to make a cell autofill information from a list on another worksheet. I have a worksheet called "PRODUCT LIST", they all have a SKU (alpha numerical code) depending on the supplier.. example... one supplier, the code all...

Hello All I'm looking for a formula to calculate the below scenario. company for example has 7 sku divided to 2 categories smart and none smart, person has target of the 2 categories and when the person achieve 100% of his target i need to calculate his commission based in different price per...

Hello Experts In the attached table SKUs 1,5 and 7 all contain blue. I want a function that will look up the quantity of each SKU that contains Blue in Table 2 (e.g. SKU 1 =55, SKU 5 =67 and SKU 7 =73) and then multiply and sum each of the quantities by the numbers in the column "Amount 1 per...

Hey folks, I've got another one for the genius residents of this fine forum. At work I run a report that creates an excel file. I've already created a master with the VBA required to clean it up so the process will be run the query, paste into the master, then run the macros and save the...

Hello, Looking for some support regarding the following question. Any SKU that Has05Reason equal to "Yes" AND Has98Reason = Yes then I want to be able to: Return a column and/or measure that says "Yes" the SKU Has05and98Reason Example1: SKU 123 would have "Yes" marked in...

SKU Reason Code Total Cost Date A123 5 100 1/1/2017 B456 98 200 1/2/2017 A123 98 300...

Apologies in advance for the ambiguous title. I am creating a sheet to automatically generate SKU's by combining product attributes. <tbody> Product Name Size Color Type Material Shape Quantity SKU 2mm Aqua Glass Rhinestone Round 2mm Aqua Rhinestone Glass Round 3k 2m-aq-rhresrd-3k </tbody>...

Dear All, I do have a sample data set across A1:E4. The data represents the NO Of BINs in which the SKU is kept at the DC. I would like to figure out the dates on which the no of BINs is more than the Modal no of BINs across a given period. The formulae put in F2=COUNTIF(B2:E2,"<>"&MODE(B2:E2))...

I am stumped! I am trying to figure out a formula and it is jut not working. I am working with SKU's and UPC's. Where I work I am dealing with product that has either a SKU or a UPC on it, and I am currently in the process of having to verify where product is in the warehouse. What I am needing...

Hi everyone, I've got a bit of a problem I do an index match of my sku's to tell me my stock levels from my weekly CSV readout. I put the data into sheet "CSV" the simply have a formula in sheet "Stock Level" that index matches the Sku in "D6" (for example) with the data in sheet "CSV" CSV...

Hey there, I'm kinda looking for ideas of how to tackle this problem. I wish to deal with some sales analysis, but first I have to fix the way data reaches us. (1) We have quite a few different SKU's, about 600. Some quite similar to one another (e.g. XXXX deluxe edition / XXXX limited...

I looking for a formula that will search a list of SKU that are similar and sum the sales totals in a cell with the Primary SKU. So a formula that looks for S650 in the data and gives the sum of all with similar SKU as the result. The example may be more helpful below to see what I'm trying to...

Dear All, The solution to this complex problem is beyond my capability and imagination but I know that this would be very simple to many excel gurus here in this forum. Would be grateful , if somebody could suggest a solution & it will save unwanted manual intervention that presently I am...

Hi All, I have been facing this recurring issue. We need to analyze the spend as per product and SKU by week, months, quarters etc. The dump from the tool is in a raw form and we end up spending lot of time in converting the data into a format which can be further used to apply pivots. I am...

I want to sum up the value for multiple lookup in the table and get their sum up value. Where i have SKU linked with another SKU and i need to know total value available. For instance - SKU 2 122233 is part of 112131 and also 142434 , however 142434 is part of 475767 also. I want a report to...

Hi, all - I have an inventory interface we use to track items that have left our store location without payment. We would like to make the interface more detailed, so we have uploaded our Master SKU List into the same Excel workbook (this includes inventory levels, item description, etc.)...