vendor

Good morning, this may have been asked but I will proceed anyway. I have a spreadsheet that we use to calculate costs of material that include the following. Material cost + handling + freight = total cost. Material cost is variable depending on vendor and manually inputted. Handling is static...

https://imgur.com/Dlb67mk I have a spreadsheet with different companies and how much they charge for gas. I need to make an if formula that will put the company name with the cheapest of each gas type in the "Jet Fuel Vendor" and "AVgas Vendor". The exact wording of what I need to do is Using...

Hi, So tax time is here again and I have to sort my statement via vendor. Most descriptions begin like this CHECKCARD 0106 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA I need to sort by vendor name, so it should read like this AMAZON MKTPLACE PMTS AMZN.COM/BILLWA. So I'd like to be able to remove...

Hi, I'd like to utilize the Data Model within Excel but the issue I'm running into is that both of the data sets that I'd like to combine have duplicate values for each of the fields I'm trying to match. Essentially I have two lists of expenses by vendor and account. On each list the vendor name...

Hi all I have a workbook with about 50 worksheets. Each work sheet is for a separate vendor each vendor has expenses divided by month the vendors are one of 7 GL accounts. I have a summary page on sheet 1. What I want is to have a formula check each page and if it finds that the GL number in...

Hello, I have a workbook, "Purchasing Workbook", which has a worksheet called "Vendor Data" on which a list of parts is manually entered in, then sent to whomever to purchase the parts. The parts are determined by a different workbook "Data Workbook", and the information is then manually entered...

I have a workbook which I need to copy rows to a new worksheet. One of the columns is called Vendor. I have 12 different vendors, but 3 of them have different entries. Let's say column "C" is the vendor column and contains the following: Vendor 1 Vendor 1 Onshore Vendor 1 Offshore Vendor 2...

Hi, I have a table in workbook "Worklist", which is used for daily worklist followup. A seperate workbook is created "Vendor check" with a table connected to the "Worklist" table, this table has 3 additional columns where you can write Things about the vendors. The issue is, when refreshing...

I wish to compare an entry that a user enters in a field to a table housed in Access. If this entry is not in that list, I want to give an error saying that the entry is invalid. We have some manual data being requested by our team to calculate savings, however certain entries are invalid and...

Hello, I am looking for some help or to repurpose a simple macro to do two things. I have a table of data that consists of a few columns of consistent data (ex. vendor names and vendor numbers) and then one column with cells full of comma delimited invoice numbers. What I would like to do is...

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

I have the following formula that returns data but is returning the wrong data. I can't seem to see what is wrong with it. Any help is appreciated...

I have a spreadsheet with two columns. One has prices from a website, one has the prices from my vendor. The vendor prices column has text in it that defines the quantity. For example, 9.99 / Case , of 15.99/bag. I need to compare the website price to the vendor price, but exclude the text...

Still new and still learning, I am close, but can't figure out how to get this to work the way I want. Here is what I have: Sub copytemplate3() Dim WS_Count As Integer Dim I As Integer WS_Count = ActiveWorkbook.Worksheets.Count Dim Source As Range Set Source =...

Hello eveyone, Im looking for asssitance on calculating a buket level and total buckets, based on a comparison to another sheet ( Red culms) In order to emphesize here is an example; Sheet A ( Spend) <colgroup><col span="4"><col><col span="2"><col><col...

Hey Everyone, Got a question I'm hoping to get some help on. Below I have copied a small bit of my code. What I'm trying to do is search out a value from a msg box insertion (called "myValue"), find another value (called "Added:"), and copy the adjacent cell values between "myValue" and...

Hi I would like to keep the same chart colors when using slicers depending on the brand vendor. However, let's assume my chart has 4 vendors Vendor A - green bar Vendor B - blue bar Vendor C - yellow bar Vendor D - red bar If I pick the four vendors it will show the colors mentioned above...

I have the following data in A1 that has been pasted from another sheet <tbody> Category Description Weight Points Vendor Score Criteria Description of item 1 6% 10 8 Criteria Description of item 2 6.5% 10 7 Criteria Description of item 3 10% 10 6 Criteria...

Hello everyone, I tried searching for a solution to this, but couldn't find exactly what I was looking for, so here I am. I have a list of thousands of items (with many duplicates) from different vendors and I need to be able to quickly pull the lowest cost of each item with the associated...

I must have fallen asleep in DAX 101, but I have a tough time testing for RELATED() values that aren't there. Example: We order products that may be substituted by our vendor. We subsequently have to revise our PO to change from the vendor item ID in our item master to the one provided by our...