supplier

Hi, I've got a spreadsheet of product data. The data is product part number, description, supplier name and various other product attributes such as lead time, cost, supplier contact and email address, etc. There's some gaps in the data, e.g. I don't have lead time for all products. I would...

Hi Ill try and keep this as simple as I can. I am trying to lookup information based on three pieces of information. I have 2 sheets Shift and Return On Shift Sheet A1 = BF B2 = Port C1 = Supplier D1 = Failure So what I need to try and get a result off is If A1 and B1 on (Shift) match...

This is part of my formula. So it's a box I click on... I enter Supplier name, department, and information of the supplier first... and then eventually ITEM# or SKU# Now, what I added was in between END IF and END in RED. Because I didn't want to have duplicate item numbers in my system...

Dear all excel experts, I have tried to use INDEX and MATCH yet still can't figure this out: Table 1: <colgroup><col><col></colgroup><tbody> Remark Currency Amt Vchr# 100799, Pymt ID# flliqtaxcc0558902062, Supplier: Dept. of Bus. & Pro. Regulation, Cash Acct - A/P Acct 67,999.13 Vchr#...

Hi, I am trying to write a macro to copy data from a master sheet, to the relevant supplier sheet, based on the name in one of the cells For example, in A1 to D1 of the master sheet I might have: 19/12/2017 | SUPPLIER A | £5000 | MANAGER A And in A2 to D2: 19/12/2017 | SUPPLIER B | £1000 |...

Hello All, Please let me start by saying that this is my first post after years of using these forums to learn excel when I only knew "Sum(A1:B2)". Thank you! I have spent a couple of days going through the best way to code something I have made to make my life easier at work. Essentially what...

I'd like to learn more about automatically making changes to tables using VBA. So, a specific issue I am currently dealing with: I have multiple Tables that are manually populated with data by users as required. The tables have Suppliers as Column Headings, and a Description of Goods or...

Hi, I have thousands of lines and trying to find the lowest value per line, yet I need to identify which supplier is the lowest by (on line 1) . Looking for help in this scenario. <colgroup><col><col><col span="3"></colgroup><tbody> Supplier A Supplier B Supplier C Result Part...

I have a pivot table that looks at supplier sales sorted descending on percent to total. Since suppliers have multiple vendor names, a particular supplier might show up as a different vendor in the pivot table. As you can see from a subset of the pivot below, Coca Cola shows up twice on the...

Hello all, I am working on a rate card for a client but stuck with how to formulate the summary, auto calculator page. I have basic level knowledge of Excel formula (tried using index match but seems like I am not good at that one !!) Data I have: 1. Drop down list of suppliers (out of 10) e.g...

Hello, I have some trouble solving the following exercise: In column M on the worksheet ‘Purchase Invoices’ use an appropriate lookup function based on thedescription, together with an appropriate logical formula to show whether the supplier for eachinvoice is on the approved supplier list. The...

Hi, I'm looking to count Unique Accounts based on two criteria: Supplier and Month Accounts are listed in a data tab in column B, the suppliers are listed in the data tab in column K, and the month is listed in the data tab in column G. Here is the arrangement of the "dashboard" I'm looking...

Hi There! I am hoping you can help, I am looking for a way to make my formula ignore blank results and only show results that contain text. My Creditors report is split by what the supplier does for us, and there are 4 categories 1. Construction 2. Supplier 3. Consultant 4...

Hi All, Hopefully a simple one, I have a table of deliveries from different suppliers, with varying columns. I select a specific supplier from the list (only ever one supplier at a time), then it shows all the products from this supplier, from 1 line to 20 lines for example. I then have a...

Hello All, I have been searching up and down trying to plagiarize various code to get this to work. I have a file that lists a series of data for all suppliers, weekly I would like to be able to split these into individual files by supplier and automatically name them as the Supplier name. An...

Hi everyone, this will be simple for anyone with half a brain cell, something I seem to be lacking. I have some data which is basically a list of supplier invoices including supplier name, date of invoice, amount due. All I am trying to do is: 1) link the data into a summary for each supplier...

I have created a workbook to keep track of orders from suppliers, I'm currently trying to build on it. I have a list of suppliers on one sheet, I have other sheets representing the a certain week of the month (1,2,3,4). On another sheet, I'm using vlookup to calculate a summary of the bill...

I am performing a new bid to our current supplier as well as 3 new ones. I have different lanes and am wanting to know the % increase we are possibly going to take. In column D I have the formula to calculate the % increase but need something else extra to have the formula automatically change...

I am performing a new bid to our current supplier as well as 3 new ones. I have different lanes and am wanting to know the % increase we are possibly going to take. In column D I have the formula to calculate the % increase but need something else extra to have the formula automatically change...

Evening all, I have spent hours searching threads for an answer to this but to no avail. I have a workbook with 10 sheets of cost codes, each with a data dump which is a list of specific costs in the cost code. I have a formula in there which picks out the unique suppliers in each dump and...