products

  1. I

    How to compare two Excel files for differences

    Hi guys/gals, I need your help. I have 2 excel worksheets. One is inventory the second is products. This is what the Inventory sheet looks like, minus 6 other columns: <tbody> Product ID Description 100006 3 PC BAR SETBLK WEATHEED; BARK 100018 3PCS BISTRO SET,CARAMEL ;BRWN/CHARCOAL...
  2. N

    Product and Accessories

    I want to Add Accesories to Main Products There are Two Worksheets( MainProducts ). Name List of Main Products. and Worksheets(Acessories). List ofAcessories of Main Products. Basically There is comman column("B") in both Worksheets(MainProducts) . Names of Main Products. and...
  3. A

    Need some creative ideas

    Hello all, I am in need of some creative ideas for the following task: I need to compare hundreds of products to each other to find products that are similar/dis-similar based on the ingredients in their recipes. See below example products to illustrate my idea. In this product set I need some...
  4. M

    merge multiple data sheets

    Hi, I have a workbook with several data sheets which I want to combine. However, each sheet contains unique data but also some same data. For example, sheet one has products with A and Value, sheet 2 has products with B and Value. So the only different thing is between the products. Because of...
  5. J

    Rolling In-Out Inventory by Date (Lookup and Sum)

    Greetings! I'm trying to create a rolling inventory for a series of products in a table that can be expanded indefinitely. Along the Y-axis are two groupings, products created and products sold. These are the only two ways products come and go. Within each grouping are a few empty cells, each...
  6. A

    Return Heading Value (Title) to multiple Columns

    Hi, I have a worksheet that contains 119K lines and 150 columns. All the column headings are unique and the columns contain specific information and data about that particular product. Some products contain data from multiple columns. Eg below - Oil Seals - contains dimensional date in 4...
  7. R

    Copy the data from one sheet to another without empty rows

    Hi All, You helped me in the past - hope you can guide me this time as well :) Sorry I didnt know how to correctly title this post... My issue: In sheet 'one' I have a simple list of products with the price, etc. Column 'C' is for quantity ('ILOŚĆ') If I type specific quantity in the 'C'...
  8. G

    Adding serial number

    I need to change my ERP system to a serialized inventory system, i have list of products and their total quantity. all i am trying to do is take a product and if the total quantity is 10, create 10 records so i can assign a unique number to each product. Example of data i have: <tbody> 2018...
  9. G

    Adding serial number

    I need to change my ERP system to a serialized inventory system, i have list of products and their total quantity. all i am trying to do is take a product and if the total quantity is 10, create 10 records so i can assign a unique number to each product. Example of data i have: <tbody> 2018...
  10. K

    How to compare two pivot tables ?

    Hi all, I got 1 pivot table showing Sales in the top 10 selling stores (rows) and top 10 selling products (columns) These numbers are based on 2017 numbers and i used the value filter to find make the table. I would like to compare how the same top 10 stores and products from 2017 are...
  11. T

    Multiple match

    Hi, I have a list of products all with a current price and a was price. I have a separate sheet which contains the history of all of the pricing on the products and I want to find out from that list, when the was price I have was live. The trouble is for some of the products I have 8 or 9...
  12. V

    Multiple Drop Down lists off of one primary drop down list

    Hi, Is there any way to create a 2 dependent drop-down lists off of one primary drop-down list? I have States, Counties, and Products as the columns. Products are the same across all counties in the same state. I've create a name range linking States and Counties. How do I link up the...
  13. J

    VBA help required

    Hi, I've got a spreadsheet of product data. The data is product part number, description, supplier name and various other product attributes such as lead time, cost, supplier contact and email address, etc. There's some gaps in the data, e.g. I don't have lead time for all products. I would...
  14. K

    Check if content of single cell shows up again in other column or tab.

    So, I have this spreadsheet that shows a whole list of products up for liquidation, it’s been altered from an original system export spreadsheet to provide better details about each product, BUT because these products are selling, the master export report keeps changing. What I’d like to do is...
  15. Y

    hide/show rows when cells in Column A are blank - based on data validation drop down list in a cell

    Hello, I have searched the threads and cannot find the solution that fits my situation. I have a worksheet with a data validation drop down menu in E3. This list is comprised of four types of services: Service 1, Service 2, Service 3, Service 4. For each service, there is a unique set of...
  16. P

    combined lists lookup

    I am converting a product planning sheet from a very manual sheet to a much more automated system. I have a customer/product matrix setup a little like below, where a '1' indicates if the customer takes the product or not: <tbody> Customer 1 Customer 2 Customer 3 Customer 4 Product A 1 1...
  17. C

    Complicated dependent dropown list

    Hi Guys, First of all, I would like mention that my knowledge in Excel formulas is limited to basic functions. My request might seem easy but I could not figure it out. I have two dropdown lists. The fist one is straight forward and gives a list of equipment. The second one is dependent on...
  18. N

    SUMIFS criteria with blanks

    Hello, I try to calculate total amounts with SUMIFS. Sheet Products contains name of products, category of products, release and end date of products and amount information on rows. Sheet Amounts is used to calculate total amounts based on categories. I have couple different criteria and one...
  19. D

    Possible? or Not? how to make a cell autofill information from a list on another worksheet

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

    Product image to show in cell based on product number (100's of products)

    Hi, I need to create a spreadsheet that shows our 25 best selling items. Each row will have the product's SKU but next to that I would like to see an image of the product. The list may be re-sorted by region so the images need to change when the list is sorted. We have about 400 unique items...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top