skus

Thank you in advance for the help! ? After extensive forum research, I decided to post since I was unable to find a comparable problem/solution. Summary I need a formula that can extract a value from within a string of text based on a list of multiple criteria to look for (e.g. if value 1, 2...

Im looking to have a line chart that shows a % for the number of sku's that were delivered on time. At present everything shows at 100% ( which is wrong, as some sku's were delivered outside of their 2 day SLA ). Im not great with charts , so could do with your help. Axis: Chart Date Values...

I have two sheets, I would like to find and match both sku's on both sheets, if the sku from sheet1 matches the sku from sheet2, i want to extract a column from sheet 2. Sheet1: <tbody> SKU QOH 1008 0 1011 0 1013 0 2135 0 </tbody> Sheet2: <tbody> SKU QOH 1008 4 1011 6 1013...

Hi. I have a sheet where I am working out product sales. In Sheet1 Column A I have all my SKUs. Each week when I product a report I want to store the current sales into Sheet2 so I can look back over time. The problem is, as we add new products, the list of SKUs in Sheet1 will grow. So I...

I need to produce a SKU GAP Fill report and would like to get some help. We have thousands of accounts and 53 SKU's and I need to find out from the sales reports from distributors which accounts are missing key SKU's. Any help would be appreciated.

below details are given on Source Code page. How can i scrap these SKUs for all pages in that particular category...

This is what my data looks like <tbody> 60633082 60633006 60633084 60633080 60633046 1 9 2 4 1 3 2 0 0 1 2 0 3 2 1 2 0 0 4 0 0 0 1 1 5 2 3 4 0 1 </tbody> This is what I need it to look like: <tbody> 1 60633082 9 2 60633082 0 3 60633082 2 4 60633082 0 5 60633082 2 1...

Hi, I have an excel sheet that has around 5000 products, i have 2 columns that are Code (C) and SKU (D), I would like to generate a report that tells me what items are duplicate. I would use the SKU to find identical SKU's so i can remove them from our system and i would also look for...

Hi, I have a small file that I can attach, if needed. It is about 400kb in size. I have tried multiple different angles on this work, but just can't seem to get this working correctly. The workbook contains (3) worksheets. One sheet is titled "PRODUCTS" and the others are "INVENTORY SKUS"...

Hi, I have approximately 58,000 rows on one worksheet which contains products, and (COLUMN A) will contain the SKU#. On another worksheet, I am bringing over a "column" that represents a certain amount of (sku's) that are the products I wish to use. So in (COLUMN B), I am pasting the column...

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

Please help, Skus are in column A, Color is column B, All I need is if column B =Satin Bronze remove 10 from the end of the sku of column A There are about 15 finishes so I will need to edit for each one but thus is the best wat to get to the base sku's. In the sample row 1 is Satin Bronze and...

Hi All: I've never used Advanced Filter and I'm having trouble getting the results I want. Here's my problem - I have a list of about 12,000 SKUs along with their price and description in columns D,E,F. I need to remove about 2,000 of those SKUs from the original list and I have those SKUs...

Hi Excel Guru's, Looking for some advice on the best way to approach what I'm trying to do... after attempting to google or search the forums I think I'm failing to accurately search/describe what I'm trying to do and have resorted to creating this thread. 1. I'm trying to first reference a...

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

Anyone hear any new rumours?

Hi all, I need some help. I have 2 workbooks, one (results.xlsm) with SKUs in Column A, and I would like keywords I have for them put into Column B. The 2nd workbook (keywords.xls) has some SKUs in Column A, and corresponding keywords in Column B. I would like to use some VBA to match SKUs...

So this is what my data looks like 2014 Usage 2015 Usage 20000007 20 11 20000007 -1 0 20000007 1 0 20000007 0 20000007 Total but for a spreadsheet that has about 10,000 items. Is there a formula that...