brand

Hi All, I have a problem. I'm no Excel expert which is why I've come here for some help. I have a price list, a snapshot is below, which is divided into three columns; Brand, Product, Price. What I'm trying to achieve, and so far failing abysmally, is the ability through a drop down list to...

I have a lot of UPC codes that are listed in an array A1:H300. In Column J is a product's brand name associated with the UPC codes from that row. I am trying to return the brand name in another workbook by looking up the UPC from the array. I just can not figure out how to do it and I...

Hi Everyone! Long time lurker, first time poster. I'm hoping someone can shed some light on a problem I'm facing with a summary sheet. I have a large set of data that includes: brands, employees (that may or may not work under multiple brands) and their commissions earned from each brand. Ex...

I have problem to code macro to select multiple item under a particular field in pivot table. The criteria for the item being used is coming from a table in another sheet (brand) Brand Brand Cde AAA BBB CCC BIO BCL PivotTableSheet (pick some sample...

Hello I am new in VBA and I am looking to build a macro to count the number of stores a responsible (let's say K) sells to, for each brand. In this example, K sells to 1 store the brand 1 and 1 store the brand 2. (so a total of 3 sales but to 2 stores only). Any help would be really appreciated...

Hi, I need help to make conditional formatting formula vba code, PFA excel file Main file and output file download file from http://pikkaa.com/excel/ I have one column (brand) and one is (Small image column) I have data in two cell seprated by | need copy that in saprate rows while...

So alot of this code is comented out. So it's pretty clear what is going on. But I'm having an error thrown in a section of the code I just added. What's confusing about it is that it worked fine in the section of the code I added when it was independent. I have the section of the code...

Hello, Can someone tell me if there is something wrong with the way I am defining my variables here? I'm not clear on what it is. Sub Insert_Map() 'We are inserting our variables Dim rngMSRPHeader As Range Dim rngHeaders As Range Dim brand As String Dim mapPolicy As String...

I want to create page using a filters data as it proceeds. the end result is a means for our salesmen to find the purchase price of different models of tractors. Ideally, the person will select the brand of tractor, then using the next box, select the particular make. (up to 30). After...

Hi All, Hopefully the title is quite descriptive here, I'm essentially trying to do as I describe; I'm trying to do an Index Match with a few criteria, one of which is a date. Here's an example below: The formula will sit in an excel sheet which will be completed with the following...

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

Hi all, I hope anybody can point me in the right direction of the challenge I'm faced with: Periodically I have to convert excel pricelists that I receive from suppliers to an excel pricelist according to a layout that can be imported in our system. Currently this requires lots of manual labor...

Hello All, Can someone please tell me if it is possible to reference a cell within a cell reference. I have the following formula and would like to be able to reference a brand # (refer to the blue highlighted text) by placing the text "Brand '#02" into a cell and then reference ing this cell...

Hi, I work in a grocery store and I am trying to make a Spreadsheet file to send to my employees that will organize the information related to the products they want to put in our weekly advertisement. I need a brand name and the number of items from that brand that will be on sale and the...

Hello, Is there a way to display Grand total in calculated field in PIVOT in columns (but display grand total of rows)? This grand total should show TOTAL value of all visible (filtered) values. I will then use this calculated field in PIVOT chart to display total planned sales of certain...

Hi there, I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below: <tbody> Product Brand Category Jan Qty Jan Sales Feb Qty Feb Sales Mar Qty Mar Sales Item 1 Brand 1 Cat 1 5 $500 4 $400 7 $700 Item 2 Brand 2 Cat 1 20 $50 30 $75 10...

I wish to calculate the standard deviation of Brand A Product 1-5 and Brand B Product 1-5. Is there any shortcut for this? I call this a brand pairing and I have 300 brand pairing to be done. Help is needed! :( <tbody> Brand Product Demand A 1 3 A 2 4 A 3 12 A 4 35 A 5 6 A 6 8 A 7...

I have to segregate a consolidated P&L, in which I have PY, CY, BUD for one brand followed by another brand and there are almost 50 brands. What I have to do is I have create a master table where in I will put in the Brand name and it should reflect the information for that brand. G1, H1& I1...

Hello, I need a hyperlink to open a macro, but I am not able to get it to work. At first I thought it was the larger code it was a part of, but I have tried both of the bare bones codes below to get a hyperlink to open a macro and it is not working. I have even tried closing all other excel...

Hello, I am trying to get at some cross buying behavior from a large data set that I have. Here is a simple, example of the data I have: <tbody> Name Product John Brand A Mark Brand B John Brand C Amy Brand A Amy Brand D Amy Brand C </tbody> And then this is my desired output...