products

  1. W

    Lookup and populate new worksheet

    Hello, I need some help from an excel whizz if possible?? Can this be achieved in excel? My bookkeeper has informed me that the following task is beyond his scope!! Objective: Populate Worksheet 3 with a list of all current active products listing the product name, brand name, quantity of...
  2. jevi

    Slicers in Excel with Sub Category - Help Please

    Hi there, I am looking on the internet for slicers with sub categories, check even the pivot tables slicers but it sound I can't understand. I need a first slicer with 5 products and than I need below each product another slicer with the sub names. Smth like below: So I need the 1 slice...
  3. N

    Form groups from list

    Dear MrExcel members, I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me. I want to make groups of x amount of products from a list. Example list: 1A34 2B43 1B544 5C45 3A52 5B32 Now I want Excel...
  4. N

    Automatic group-making from list

    Dear MrExcel members, I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me. I'm looking for a macro/vba code/solver solution for the following problem: I want to make groups of 4/5/6 products that are...
  5. B

    Matching cells' values (cell contains a string from another cell)

    Hello! I have a problem, which I'm thinking about for some time already and didn't find any solution yet (and have to do it manually). I have two columns in two seperate sheets: FIRST contains shortened names of some products (for example: "Lamp") SECOND contains full names of these products...
  6. R

    VBA Product of Arrays

    I have a code that is taking vertical data from one sheet and scheduling it out based on an "OnStream" date that is predefined. It returns a row of data for each component type. The next thing I need to do is multiply insert a function that multiplies each of those rows by a set row from of...
  7. N

    Finding possible combinations

    Hello all, I'm having this problem with our company's products and what combinations are possible. The following is the situation: <tbody> CUSTOMER_ID PRODUCT_ID 1 A 1 B 1 C 1 D 2 B 2 C 3 A 3 B 3 E 3 F 3 G </tbody> I have specified for each customer what products they...
  8. A

    Transposing Product Attributes from Columns to Rows

    I have a large batch of product information that I am looking to reformat so that it can be imported to our website. Below is an example of the format that it is in now is: <colgroup><col><col><col></colgroup><tbody> SKU Number AttributeName ProductAttributeValue C01 Width 2.6" C01 Length...
  9. R

    Is there a question and answers product available?

    I am an analyst and I use a little Excel 2003 VBA. It is something I really think I could enjoy and make a full career out of it. I have seen some of the books, and CDs, but I was wondering if there is something like a "questions and answers" product, that I could use off my laptop on the...
  10. A

    Looking to Simplify Process in XL

    I get Lists of Client names daily that I need to sift through to simplify. I spend a good amount of time doing this daily. I would much appreciate some pointers on how to simplify the process. I initially sort by Term to find items that match the criteria 1030-1060, for the purpose of...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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