suppliers

I am wanting to show the top 10 suppliers by spend and show their respective percentages of total sales. Pivot table easily gives me Top 10 but the options for % don't give the opportunity to compare each of the suppliers spend amounts to total sales, as opposed to % of top 10 spend. any...

I am trying to make a list of all suppliers my company has used this month. I want the pivot table to show the rolling 12 month period of the information, but only show the suppliers that have a value for the current month. Currently it will only show this current month of data and not the full...

I'm trying to create a spreadsheet to control account reconciliations in my team. We have a list of suppliers that the team work through and they highlight the suppliers accounts when reconciled. I'd like to add today's date to another cell when the supplier name cell is highlighted, so that I...

Ok, I have been tasked with a new project at work and it is honestly out of my scope, I have told them I will look into it but wow, this is hard even if it is possible. We have multiple suppliers at work and my employer wanted me to create a workbook that will track all the spendature with the...

I have a master price list for ordering stock and the following code works as long as I'm always ordering from all suppliers. I filter out the all items which are being ordered when quantity required column is greater than zero (field 11 > 0) Then I filter by supplier column (field 2) and copy...

Hello I am in need of some help when adding the overall grade as well as grade weights. Right now I have N/A's (Column P-R) defaulting to 1 if there is no grade.I am afraid this is still not correct. I think the grade is being over inflated with N/A's making the supplier's grade look better...

Hi I have a question wrt to an existing thread: https://www.mrexcel.com/forum/power-bi/1064965-dax-cross-filtering.html The diagram below shows the model and the solution was: [# Contracts] = CALCULATE ( COUNTROWS ( Contracts ), SuppliersProducts ) = This all works fine but my issue is...

Hi, I'm reading and using all the codes posted in most of the threads but I still found difficulty in running smoothly in my worksheet. May I ask for your help to formulate a code that will sum up all the duplicates in Criteria Range- column I (it will not include blank spaces) and sum range...

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

Hey, I'd appreciate help with 1 excel spreadsheet and duplicate values that I would like to remove. I've got information about some collections at specific suppliers for each week of the year. Example Week Supplier Missed collection Week 1 SU1 YES Week 1 SU2 YES Week 1 SU3...

CURRENT SCENARIO The functions below create a custom SKU based on a hard-coded supplier and its respective URL syntax Excel 2013 32 bitABC1ExampleSUPP URLCUSTOM SKU...

cheers everybody, I'm a newbie to VBA and decided to undertake a task to automate a report regarding supplier evaluation. I have managed to automate all the actions needed to provide input data to my final excel sheet, created UserForm and ListBox and got to the point where my code copies...

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. I have a question. This is what I want to do; I have 3 or more suppliers and every supplier gives me price list for items. I compile them into one excel file. I could choose only one supplier and I need to buy all items from that. For example, I have item list on the first column...

Hi all I have a file with 22.000 lines. They contain our stock codes plus their suppliers (plus some more information but not relevant for this thread). I want to create a separate excel file (or CSV, whatever I can get) for each supplier as there are over 300 suppliers. I suppose someone...

Hello, I have a data set similar to below. Each lane ID has a base price that I am paying now. I have had suppliers return bids and I have ranked them compared to the base. Column D has the formula =countifs(a:a,a2,C:C,"<"&c2)+1 this allows the formula to be filled down column D but when the...

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 working on a purchase order form that have multiple suppliers and different prices. I already searched the forum related to what i'm doing but it seems I can't find similar case. I used data validation for my pick list and basic vlookup function to display the item and corresponding price...

Hi All, I need your expertise help with this please! Work has tasked me with an excel spreadsheet and I've played around with it, but can't get it to function properly and need someones help with more knowledge. What they want is a master spreadsheet of supplier payments for the year (April...

Hello, I'm using excel solver and have a problem I can't figure out. Here's an example: suppose I have 20 suppliers and I want solver to find me the lowest cost based on a set amount of suppliers. For example, I may want solver to give me the lowest cost using only 5 suppliers in one scenario...