product

Hi, Please refer to the image in the link below. I’m trying to create a data validation that lets a user choose Product and Colour of a car from the Manufacturer. Is there way to put some function in data validation list option so that it looks for Audi on the worksheet and takes the...

I've seen a few of the forums in here with similar requests - how to take a column of data and where there's matches, total the sum of those cells. The consensus seems to be to use SUMIF instead, but I do think I need to use VLOOKUP. My goal is to analyze the data, and output a tallied set of...

<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody> Maximum Length 20 Product Information- User Input Generated SKU Code & Product Explanation Product Category Product Name Attribute1 Attribute2 Attribute3 Product Explanation Generated SKU Code Modified SKU Code SAS...

Hi, So i am trying to create an Excel template were I can export data out of an ERP and paste it in an excel template to help extra the start and end dates. The first row shows you what im trying to pull out of the data from Paste Info column. For the most part there will always be ". . . ."...

Hi, I have a list of products and associated dates. A product will have multiple materials and each material have a expiry date. Something like table below. <colgroup><col span="2"><col></colgroup><tbody> Product Material Material Expiry AA a 16-Aug-23 AA b 17-May-23 BB b 18-Aug-25...

Hi, I have the below tables and I am trying to match back avalue from a separate product table & then output a calculation dependingon the value found. I have the below formula which looks fine to me but I cantfigure out why it only returns a 0 value. The formula should find Product...

Hi Guys I have a limited knowledge of excel, but unfortunately I have been volunteered to implement the below: I want to able to do the following: 1. scan a product in that it registers in excel 2. then scan it into the stock location area 3. then scan the quantities , I presume we have...

I have a workbook that contains three validation cells, 'Brand'; which has two values, 'Customer' and 'Product', both which have multiple values. Two seperate datasheets (tabs) for each 'Brand' contain the 'lookup' data, both containing columns for 'Customer', 'Product' and 'Discount' Im trying...

Hi please see the photo in the link; https://ibb.co/RPmLYTz Is it possible so that A16:A24 will display a product code and C16:C24 will show the total amount of each product?

I've tried really hard to find an answer to this problem but cannot find it. Basically I have an table which is populated as below: <colgroup><col><col span="5"></colgroup><tbody> Band 1 Band 2 Band 3 Band 4 Band 5 Product Group A 10 25 40 55 60 Product Group B 15 20 25 35 40 Product...

Hello all... I have code for a searchable combo box, that is working just the way I want it to. Private Sub ComboBox1_change() Dim i As Long For i = 1 To Application.WorksheetFunction.CountA(Sheet2.Range("a:a")) If LCase(Left(Sheet2.Cells(i, 1), 1)) = Me.ComboBox1 And Me.ComboBox1 <> "" Then...

Hello, I'm looking to extract product numbers to do some analysis. I get them in a format that is this: /product/12345/product-description The part I need is the "12345" (the product number). Sometimes the products are displayed like: /product/12345?product-description or /product/12345 The...

Hi Everyone, I was hoping for some help with a piece of code that keeps tripping me up. I work for a store and have lots of pages relating to different kinds of product. I'm attempting to add them all to one "master list" that contains data for a pivot table. New products get added via a...

Hi all, I've got a file where I have multiple products and they have certain characteristics. These characteristics also have values. I need to lookup which products only have the characteristic value of "rain" or "rain" AND "fire". If a product does not meet this criteria, the lookup should...

Below is the beginning of my code, the only issue I'm having is that the below list when deleting should only delete on an exact match. So for example if I have 'carrier name' as a column header and 'carrier name 2' as a column header by the list below only carrier name column should be...

Hello, I have 3 numbers that were given to me that are $/SF weighted averages. The developer didn't provide the weight factored into calculating each average. <tbody> Total Project $/SF Average 1st Product $/SF W. Avg 2nd Product $/SF W. Avg 3rd Product $/SF W. Avg 379 398 339 289 % of...

Hello! I have a table to be filled in with the prices of some products from different offers. Some products are acquired in the Euro currency and the others in the RON currency. My question is if is any possibility (macros, formulas) so that when I insert the value expressed in one currency...

Hi all, I'm really sorry as I'm struggling to even describe what I'm asking help for here. I basically have a list of 30,000 rows of data where Column C is the unique number relating to a customer and Column D is a product they hold. I'm looking for some code to do something like run down...

Hi Is there a way to sum one column only if the values in another column are populated? So in the example below, there are 5 products: A - E in column A. Column B states whether or not a product is 'Live' And column C has the sales data for that product. I'd like to sum up the sales of...

Hi All, I have the data of Product in Row A and its price in row B. Similarly Product in Row C and its price in row D. in Total having 3 list of products and prices. Maximum 10 entries user can enter in each row. I want all the products from those 3 rows in single row G and its price in H...