supplier

Hello, need advice with the following Quantity is at column 2 and supplier is at column 3. If the quanity is zero do not send the email at that specific supplier I attach the code Application.ScreenUpdating = False Sheets("ORDERS").Select Columns.EntireColumn.Hidden = False...

Hope you can help I am trying to create a price comparison tool over 3 columns. Column A is the default supplier price and columns B & C are alternative supplier prices. What I would like to achieve is: If the value of Column B2 or C2 is the same as Column A2 turn Cell Amber If the value of...

Hi, Im looking for a Macro or code to use, that would automatically to move a row of data when a criteria goes from 'Open' to 'Closed'. I want the data to move from one sheet to another sheet in the same workbook, but also want it to move down to the next row. The information looks like this...

Hi, I'm looking for vba code to check if column A has a value then column C must also have a value. I would like it to prompt me before saving. Basically its a supplier list and if a supplier name is listed in column A then the commodity they provide must be filled in column C to comply with...

Need help to create a drop-list to only show Part No related to Supplier tbl_supplier_partno (table is dynamic) <tbody> Supplier Part No K MART 111 TARGET 222 TARGET 333 COSTCO 444 K MART 555 </tbody> $H$8: K MART <tbody> G H 8 Supplier: K MART </tbody> What...

Hello World! I'm not sure if this is the right section to post this, but I'm needing some help. As of the beginning of July my company opted to ditch Microsoft Office (To cut expenses) and moved to Google. And that ruined a lot of my macros. I have no idea of how to script in google but I've...

I am reporting on supplier rejects over a 3 months period. I have a list of events with supplier account numbers in column F. I want to strip out the unique occurrences and rank them into a top 10. this is my working formula as an array. (probably over complicated but it get the job done)...

Hello all A member of the Excel forum kindly helped with this code and I want to expand it to saying. Number of supplier email missing Proceed Yes or No if yes then action my code if no then end function With Sheets("Data") LastRow = .Range("B" & Rows.Count).End(xlUp).Row Set...

HI Ihave a set of data (see below). I want to count “YES” and the more “yes”supplier have the darker colour the result it should be ( in this way I canshow which supplier I should pick) Icouldn’t figure out a way. The only thing I can think about is percentage. Cananyone help me to find a...

hi guys, Need some help on a file that needs filtering though a drop down list. Background: there are different quality of oil shipments that we are getting from the supplier vs the contracted quality that we agreed upon. Every sample of oil is presented into a table called the crude oil...

Hi All, I have a workbook that contains 2 worksheets. One worksheet is the supplier inventory data, titled ("Rugs") and the other worksheet is what I use to import into my website, and it's titled ("Store"). What I do, is I link each cell of data from the ("Rugs") worksheet to the cells in...

Hello I'm not sure this is the right title but I'm hoping someone can help. I have a very basic model re supplier data (2 dimension tables and 2 fact tables). I have listed the tables and columns below. Dimensions (Supplier list) - supplier ID (Product list) - product ID Facts (Supplier...

Hello, I am working on a macro that takes the data from my source worksheet (this includes a list of clients with unique supplier ID numbers, as well as dollar transaction amounts for multiple types of accounts) and organizes those transactions in a new worksheet by supplier ID, transaction...

Hello I'm hoping somebody can educate me around this puzzle. I've been trying to sort descending on a basic calculated field within a basic query. The ORDER BY clause refuses to work however (keeps prompting for parameter values to be entered) unless I use the field position indicator...why...

Hello, I am trying to do a lookup based on a variable file name which I'd like to fetch from cell I2. I am very new to complex excel formula so am hoping someone can tell me exactly what I need to do to make this work! I've tried looking around other peoples posts on this and adapt it but get...

Hi All, Very new to VBA and learning on a daily basis albeit very slowly. However, I have a project which needs to be completed urgently and hence reaching out for help. Project Details: The business has set up a new warehouse facility. We have 100+ suppliers who currently deliver into 5...

Hi, could you please help with a question regarding excel queries? I've got a query where I'd like to remove duplicates from ( name of the supplier), however I want to do it only for each week, not for the whole file. Is there a way? Thanks Agata

hi, I have multiple suppliers that I ask them to supply plumbing items that I choose at their best price. My trouble is the suppliers are becoming more eg. 10 suppliers. Each supplier can supply their 'own brand' of tap or Pipe Each supplier may have a different QTY for what they are...

<tbody> A B C D E 1 PRODUCT Q1 Q2 Q3 TOTAL 2 VOLUMES - SUPPLIER 1 1 2 60 3 VOLUMES - SUPPLIER 2 1 25 4 5 (On separate worksheet) SUPPLIER 1 SUPPLIER 2 Q1 50 45 Q2 5 8 Q3 15 25 </tbody> Hi - can anyone assist, what...

I have 2 tables that I am trying to figure out a less painful way of merging into a single table or identifying some other method to link the 2 tables. I currently have 2 tables that report on supplier information. Table 1 shows by supplier what category or categories that supplier supports...