sku

I have a large spreadsheet with different columns with varyingnumbers of product item rows below each SKU heading. I have a routine whichcopies the product range and dumps this into column B in Sheets("Dump").This works ok. Set ActSheet = ActiveSheet ActSheet.Range("A" & Product &":" & "A" &...

Hi How do check if H2 = B2 and have a message if not , I have this so far. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "H2" Then If Target.Value <> "B2" Then MsgBox "Wrong Sku!" End If End If End Sub Would like it to work on all cells in H and B

Hi team, I am stuck and any help is highly appreciated. Have 3 columns as below. SKU id can be anything. I need help trying to have a formula for column C. If the SKU is used for first time column C should say NO . I tried =IF(COUNTIF(C:C,C2)=1,"No","Yes") but its not useful in this condition...

Hi Message board. I'm looking for some help. I have a really horrible data set (stock board) that it 14 rows tall per sku and 39 columns wide per sku. i need an sumif to loop through the data set and change the 5th row of each 14 row block of data, there is around 100 skus in the data set so...

Hello, I am trying to convert some data currently exported as below: <tbody> Order Number SKU Price Order1 sku1,sku2 $1,$2 Order2 sku3,sku4 $1,$2 </tbody> We need this transformed in excel into something like the below: <tbody> Order Number SKU Price Order1 sku1 $1 Order1 sku2 $2...

Hi, I have a list of sku's that I always edit and add more and I have a fixed list of sku's in another sheet. The first list is my inventory and the second list is sku's specific price that I have to use. How can I "run a scan" on the first list of the second list sku's and if a sku matches...

Help with returning adjacent text cell for the maximum occurrence within groups of IDs Data: <tbody> ID (A) CODE (B) SKU Count (C) Code Occurrence (D) Code % Of Occurrence (E) Max Occurrence % (H) Results Needed 1 A 6 4 0.67 0.67 A 1 B 6 2 0.33 0.67 A 1 A 6 4 0.67...

I have an existing function that creates a hyperlink because the syntax of that URL is baked into the function. This works perfectly fine for a single website; however, the solution becomes obsolete and inaccurate when multiple websites are thrown into the mix. In the sample below, Column A is...

CURRENT SCENARIO The functions below create a custom SKU based on a hard-coded supplier and its respective URL syntax Excel 2013 32 bitABC1ExampleSUPP URLCUSTOM SKU...

Hi, I just need a little bit of help with this code. I just about have it but not quite. I need to match 2 different columns in 2 different workbooks. I need to match column b (sku) on workbook datafeed.xlsx to workbook result.xlsx on column b (sku), as shown in the code. If no match from...

Hi Guys, I need some help finding a formula that will give me the total sales units of an item where I need to add the sales units of the "Parent" and the minimum sales units of the "Box" that relate to the item. For example below, Item 1 is the sum of Item 1 (Parent) + minimum of (Item 1 Box...

Hello, I am in the middle of writing a formula that evaluates whether or not a column has any duplicates in it. The problem is, is that I don't know how to make the formula evaluate duplicates where that condition is met. If the header is "SKU" then I would like the formula to count the...

Hi all, First time posting, sorry if I don't adhere 100% to the format but I'll try. I have 2 sheets, sheet1 is a promotional grid with SKU codes in column 1, and 52 columns (weeks) to the right which will either be blank or have a promotional price for each sku code for that week. SKU ...

Hello everybody, This is how looks my table (for better view look here) My goals here are : When somebody enters a data in SKU column which is matching to already existing one the new data will go one roll below the old data and copy several details like Description, Unit, Cost...

Hello everyone, First let me explain what I am doing because there may be a better way of doing it. I am creating an excel for a set of users. They will enter in a SKU, and based off that sku I want it to pull due dates for that project, as well as populate a template for the category that sku...

I have spent all afternoon and failed to find the correct formula. Reaching out for some help. We have a basic excel with 2 Column and 5000 rows. Column B is our SKU - FCA001, FCA002,FCA003 and so on. Column C is our image links example below. I am trying to find a rule to check the SKU...

I'm wanting to concatenate some rows dependent upon if they are a different value. So in column C i want to say =IF(D2="Variable",concatenate(c3,c4),c2) So i need the formula to check if parent sku is the same as the child sku, then if it does, then concatenate both of them skus together, and...

hi everyone, i have a power pivot that contains different metrics for every SKU in different dates, like this: <tbody> date SKU ID color forsalestock 2/8/2018 293774 red 15 2/15/2018 293774 orange 10 </tbody> i want to rearrange this power pivot to reference specific column for every...

Ok, so its been 14 long years since I last tried to touch Access. I feel as confident now as I did then, lol I'm trying to slowly build a master database. Here's where we as a company currently stand. Currently on approximately 100 excel sheets we track part numbers, current on hands...

Hi, I'm thinking this should be a pretty simple formula, but nothing I've tried has worked for me. My sheet calculates pricing differences between two sources for different attributes (in this case A, B, and C attributes). Some cells are blank, some cells contain "0", and some cells contain a...