products

  1. B

    how to bring in all the matching rows from a different sheet?

    EDIT - I can't use VBA at work so I'd appreciate a non-VBA option please :) I have two workbooks that I need to play with. Both have an Opportunity ID field. I'm using the first one for most of my work, but the second one has a Products field that I need. Each Opp ID is associated with one or...
  2. C

    Need help with formula

    I have a spreadsheet with products and prices. I need in my sales spreadsheet that if the product name is B the price is C, if the product name is D the price is E etc. I have around 80 products. I have tried all the way possible with the IF function but cannot make it work. Thanks
  3. K0st4din

    Macro prints barcodes according to the number of products

    Hello, everyone. after a long search on the Internet, I managed to find a table with which to make barcodes. the table has one worksheet, I revised it to have two more worksheets and a total of 3. The first will be the arrived commodity database. in the second worksheet I have made models in...
  4. L

    Excel I'm working in 2 different workbooks and matching product codes for my website

    Hey Guys and Gals, I am trying to do a bulk upload of products to my website, the suppliers have sent me the entire product range as a CSV, but I only stock a fraction of the products. What I want to do is to copy and paste all the information from them in to my workbook which I have exported...
  5. J

    VBA drop down menue to hide and unhide rows

    Dear all, I have searched online for a solution but was unable to find exactly what I need. I have a spreadsheet to include products in a particular section. I have designated a section of 10 rows for the products I wish to enter. I have a drop down menu/ list with the numbers 0-10. I would...
  6. W

    Delete a list

    I want to delete a list of products that are scattered through the rows of the sheet. is there a way to do that without going to each one manually?
  7. G

    How to combine all cells equal or close to a given value

    Hey... I'm a newie on Excel and I've seen a lot of smart people around. any of you came across the given exemple below? I've got a column of different products, and I'd like to find all combination of procucts up to a maximum value of 2,45 meters and count all those combinations to optimise the...
  8. R

    Combining two tables

    Hello All, I have problem with creating a new table with correctly sorted data. Here's the issue: I have two tables with data, first one has a columns named: "product" and "date". It has the dates related to the product. I have also other table (in another sheet) with columns: "product" and...
  9. J

    Excel function: Restricting list of products appearing on drop-down list

    Project: I'm using Excel to create a receipt/invoice for buyers at a local high school auction. I have three pages in my excel workbook. First page: Buyer information (this will include their bid number), second page: products, third page: receipt/invoice. I'm using VLookup to grab the...
  10. H

    Excel like POS

    Hi, I would like to build simple excel file to be like POS in small Market. Attached is my file. In sheet1 there is barcode, products, price, Quantity and so on..The idea is that in sheet2, to the column A will be intered products barcode from scanner, and the other dates(product name, price...
  11. B

    How to find non-duplicated dates (VBA)

    Hello! I have a product report that has some columns - one of them is date: one of two specified (let's say that it's always either 1st January or 9th January). Among all products there are few that always have only one date assigned, but still appear many times in the report (because other...
  12. S

    SUMPRODUCT Change the value of text along with date check

    Here is my equation: =SUMPRODUCT(--(MONTH(A2:A12)=2),--(B2:B12=ʺBUNʺ),C2:C12) It works how it is, I want to select a range of dates, and sort using only the month, and then how many times that a certain product was used during that month. Because of SUMPRODUCT all text value is zero, so I...
  13. M

    nested if statement problem

    Hello all, i cant find why this doesnt work =IF(VLOOKUP(C2,'cost prices'!$B:$J,9,0),VLOOKUP(C2,'cost prices'!$B:$J,9,0),IF(VLOOKUP(C2,'cost prices'!$B:$I,8,0),VLOOKUP(C2,'cost prices'!$B:$I,8,0),IF(VLOOKUP(C2,'cost prices'!$B:$H,7,0),VLOOKUP(C2,'cost prices'!$B:$H,7,0),IF(VLOOKUP(C2,'Kit...
  14. K

    Finding a certain value from a list of matching values

    So what i am doing is scanning barcodes, the only problem i have is that the barcodes on products are all the same. I have several distributors that supply the same products but at mostly different prices. I would like to be able to tell excell to find that product ( which i have already done...
  15. K

    Finding a certain value from a list of matching values

    So what i am doing is scanning barcodes, the only problem i have is that the barcodes on products are all the same. I have several distributors that supply the same products but at mostly different prices. I would like to be able to tell excell to find that product ( which i have already done...
  16. G

    Adding rows in between varying group sizes

    To set the scene: I have 800 or so products, each with a unique identifier. These products have associated notes on a system, each with a varying number of notes. These notes are managed on an Excel document. Therefore, on a spreadsheet, I have groups of products. Some are in groups of 2, some...
  17. L

    Basic Search ISNUMBER/LEN formula help!

    <tbody> Products Colour Number of Smooth Doors = 25002770 Number of Blue Doors = 46004100 Number of Red Doors = 30003150 2x30003150, 2xMRC2562, PAD2500, RED 7 4 6 4x46004100, 2xmrc BLUE 4x30003150, 4xmrc, PAD250 RED 5x25002770 Cream 2x25002700 Cream </tbody> Hello, just...
  18. RJSIGKITS

    Hlookup - Is this the best way to do what I need?

    Hi Guys. So, I have a sheet that has a 'Shopping list' with a load of products that need to be ordered for a specific 'Model'. Column A = item description Columns B-D (random other info) Column E = cost price per item. Columns F to K = Qty - all columns have the model names in Row3 (F3:K3), and...
  19. F

    Excel Formula

    Hi, i have a spreadsheet with 4 columns with headings and many lines. Each line per column contains either a Y or a N, ie Col1-N, Col2-Y, Col3-Y, Col4-N. I'm trying to determine (total) across all 4 columns how many lines contains ALL-Y and/or Col1&2-Y or Col2,3-Y or All Columns = N, etc. The 4...
  20. P

    Autopopulate drop down box

    I have a spreadsheet which I am using vlookups. when I enter an item it will auto populate the product code into another cell. The content is also from a validated list, though has over 2000 products. is there a way of typing the start of a name to locate products that start with those letters?

Some videos you may like

This Week's Hot Topics

  • 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...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

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