vendor

folks, I need to set a Yes or No flag for a list of vendor numbers based upon whether or not they appear in another sheet and have an associated positive dollar value. I use this Yes/No flag to decide which statements I have to create and print at the end of each month. Currently, I use a...

Hello all, i have 2 listboxes. one is populated by a command button, it sets a list of vendors. from that box a the user can click on a vendor of choice, the second listbox will then populate with the parts that are at the chosen vendor. (both are dynamically created arrays) my...

This macro was working but when I put the raw data in the spreadsheet to test it out in worksheet "A", it inserted columns "F" and "G" in worksheet "B" instead. That is all it did. It didn't insert the formulas into columns "F" and "G". The debug box came up and when I went to debug, the part...

I have a question that I'm not sure is even possible. Let's say I am creating a spreadsheet that has budgeting info... Budget owner, vendor paid, date, etc and then at the far right of the spreadsheet I need to list each invoice number and invoice amount (typically 5+ invoices per vendor). This...

hello everyone, tried doing with dax and regular excel methods but scratching my head here is a table example. the "style" number is repeated because there are multiple vendors that source the product. i simply want to concatenate each of the vendor names together separated by a comma. how...

Hello, It has been a while that I popped by here but everything worked for me without issue’s until today. I have a challenge and I just can’t find the solution right now. Following problem: I have a workbook with much data, it is an invoices dump from SAP, I will spare you the details. Let me...

Hi Everyone! I'm digging around the ole Google world to see if something is possible or if software exists. I current can export a file from a vendor and it contains information that I want to import to another vendor. The issue is the column names do not match so I have to stop and tweak the...

I tried to google this, but didn't know how to word it properly so couldn't find a proper non complicated solution. I have a table called 'Accounts' with all the account information. Right now when I open the userform I have: Private Sub UserForm_Initialize() AccountBox.List =...

Sheet1 is vendor number and vendor name. Vendor name takes the form of a hyperlink formula that links to their homepage. (i.e. so the text that displays is Microsoft but if you were to actually click it, it takes you to microsoft dot com) Sheet2 contains the vendor number. The goal is to do a...

Hello I have an ISO 9000 Requirement to track Vendor Performance. I need help tracking performance in Percentage on on time delivery. Pivot table: Requested Due date: C7 Vendor Name: D7 Date Received: O7 Performance Rating: P7 (Unable to determine % based on Completion dates Vs Due dates.)...

I have a pivot table that will sum by vendors with product number, product name & returns the total of each. What I need to do is calculate % to total of each vendor (not grand total). I am missing something but I cannot get this to calculate. Any suggestions? Thanks

This code works perfectly in the the first row only. I tried to add loop but keep getting errors. I need this move down a row and continue moving down. This is my first time doing this and I have been researching for hours. I have been using a function but i have to many conditions to list. Sub...

I am trying to optimize the following and not sure how to do so. I have a list of 50 items. Let's say ten of them need to return a value based on the item in the list whereas the other 40 need to simply return a default value. For example, I have a list of vendors and need a column for the...

I am looking to automate the purchase and receipts of goods into inventory by day. The catch is that one SKU may have multiple vendors and I would like to utilize a FIFO method so that when I sell a product, I deplete the oldest inventory first and then switch to the next oldest which many be a...

I am trying to figure out if there is a way to have a "table" automatically generate for me using the new dynamic array functions. I put table in quotes because I know it won't be an Excel table as dynamic array functions don't work in them. I have a table (real table) with 4 columns: Date...

Hi, i have an input table which i want to convert to the output table using Dynamic Formulas/Functions.. Request help on this.. Input Table: (X1..X9 represent column headers) <colgroup><col><col span="3"><col><col span="2"><col><col></colgroup><tbody> X1 X2 X3 X4 X5 X6 X7 X8 X9 NQ...

Good morning, I am trying to come up with an innovative way to extract the date from a file name. We have a vendor that bills us using a spreadsheet file every month. I store the files in a folder and have power query join them from there. The vendor names the files 103118MDS_Detail every...

<tbody> Vendor Project PO Asset Apples Galore Fall 10 11 Green Apples Galore Fall 20 22 Yellow Johnny Appleseed Fall 10 54 Red Johnny Appleseed Fall 20 67 Pink Johnny Appleseed Fall 20 67 Peach </tbody> <colgroup><col width="514" style="width: 386pt...

I have a data list that need to have pivot tables created for them. Example of list: Vendor Name Amount Rep Name Vendor A $100 Lisa Vendor B $200 Kim Vendor C $250 Marie Vendor B $50 Kim Vendor C $75...

# Hi, can anyone see why this code is bugging please? Sub CopyFltr() 'DECLARE VARIABLES Dim Ws As Worksheet Dim Cl As Range Application.ScreenUpdating = False Set Ws = Sheets("Import") 'FILTER ON EACH VENDOR ON IMPORT TAB If Ws.AutoFilterMode Then Ws.AutoFilterMode = False With...