vendor

Hi I have the below code which I was hoping would scroll through some worksheets in a workbook, and delete certain ranges of data. However, it is bugging at "Sheets(sName).Sheet. I am using the list of vendor codes on a separate worksheet as a collection. Can any of you guys see what I have...

Hi mvps! My goal is to find out the vendor that the customer ordered from. In my lookup table (AP Report), I have the vendor name, and my criteria columns: customer name, itemnumber and the posting date. The customer and item number are exact matches, the posting date however, can be the same...

Hi, I wonder if anyone can help me with this, I have a list of vendor codes in column B on a worksheet called "Import", and I need to filter on every vendor code in this list, and copy the filtered range to another worksheet, the name of which will be the vendor code. Below is the code I have...

Hi again! <colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> My formula isn't working as intended anymore. Here is what I wanted: I have 3 worksheets: WS1 WS2 WS3 WS4 Vendor name Expiry date Formula field Vendor name Vendor...

Hello, Looking do do a vlookup to pull back multiple records for the same lookup value. for example in sheet1 starting A1 <tbody> Item Vendor 1234 11237 </tbody> I want to lookup all values that start with 11237 in sheet2 starting A1 <tbody> Vendor ship 11237-00001 11237-00003...

Hi everyone, I got lost trying to do a formula... Hope you can help me! I have 3 worksheets: <colgroup><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>...

Hi everyone, Can't seem to make this work... I have a table like this: <colgroup><col><col><col></colgroup><tbody> Vendor invoice nr invoice date Alfa 1 11-10-2018 Beta 23 10-02-2017 Beta 24 01-03-2015 Delta 58 06-04-2016 Delta 59 07-04-2017 Delta 60 08-04-2018 Gama 70...

In my sample file below I would like to move the details associated with a specific vendor number to a sheet in the same workbook. In my example file for instance lines 3 and 9 are both for the same vendor. I would like the info from those lines to populate the tab titled Jeff's Drywall and...

I have a list of data that that has two options: "Vendor" and "SearchTerm" As of right now my data looks like this: Column A Column B <colgroup><col><col></colgroup><tbody> Vendor 1000056 SearchTerm MACHINE PARTS Vendor 1000059 SearchTerm MACHINE PARTS Vendor 1000065...

I am need a formula that will will search column B for the words "Vendor" and "SearchTerm" and bring back the results from column C. For instance: Column B Column C Vendor 1000056 SearchTerm MCMASTERCA

Hi folks, I have the following lookup: =INDEX('[Form-0439 Vendor Performance Assessment 2016.xlsx]Revised'!$AU:$AU,MATCH(A:A,'[Form-0439 Vendor Performance Assessment 2016.xlsx]Revised'!$B:$B,0)) What I want is to change the lookup each year to reflect the year in the form name. I was...

From a vendor work with, I received an Excel file with formulas giving the product of two other cells - for example, cell C3 should be the product of cells A3 and B3. But instead of simply using the formula =A3*B3, the vendor used the following: =SUM(A3*B3). I don't think I've ever seen that...

I have another one for you. I have an inventory sheet I get from a vendor every week. All I need are the columns: Product Code QTY in Stock I would love for them to pull from all 5 sheets and make them one long list. I can't remember how do to that in PowerQuery. I get an updated inventory...

Hello, I am trying to modify a formula that I have working, but I need it to pull duplicate values for the same return value that is found. I have looked at other posts on this forum similar to my question, but it seems all them are not as complex as mine. I've seen some index/match formulas...

Hi genuis', I normally do pretty good piecing together code to make my little projects work; however, I think I am in way over my head on this one. Basically, there is a form creation that I would like to automate for my team to save them data entry time. I have spent days trying to figure...

I have a vendor that is billing invoices, and overtime has billed hours multiple times. How can I show the item and hours for each invoice to show a running total?

Hi. My apologies for asking a question that seems to get asked frequently. However, I was not able to figure out a solution from the previous posts, and I have not been able to find a video on the Mr. Excel or ExcelisFun youtube pages that go over "Duplicates" errors in Power Pivot. I am hoping...

Alright so tubular layout got me half way there. Each row in the data sheet has 3 vendors per item. My issue is with filtering. <colgroup><col><col><col><col><col><col><col></colgroup><tbody> Item Number Vendor 1 Vendor 2 Vendor 3 Sum of Sourcing Sum of Manufacturing Sum of IC/QA Corn...

Hi, All! Carter here. New to posting; long time forum reader. Decently familiar with Excel formulas; aware of but new to VBA. I have 2 Sheets. The 1st Sheet is for entering information into a Table for a Bill of Materials (BOM). One of the pieces of information for the BOM is the Vendor of...

Hi I want to filter the table below and then find the subtotal for that vendor. For example I want to filter vendor A and find the subtotal then filter vendor B and find the subtotal. Can I do that? I tried subtotal but did not work? I tried =sum(b1:b10) but that would give me the total but the...