vendors

Acess 365 I have a form called vendor (shows a list of Vendors), with a subform called VendorVariable (to add a Vendor that is in the t_Vendor table to the t_VendorVariable table. I then want the Vendor added to the t_VendorVariable table via the subform to delete the same Vendor from the...

Need your advice on the best way to handle vendors that are the same just called differently in the data I receive. One data source may call the vendor something different than another data source. I.e. abc co. Vs abc company. Or St Joseph’s vs Saint Joseph’s. What is the best way to handle...

I have a general question about how to set up a slicer used with several power pivot charts. I have two charts that share a timeline and display company totals and I have a slicer that allows for individual vendors to be selected. Everything works as intended, the only problem is that for this...

I am conducting a bid. I have 5 items I want to purchase at varying quantities and am receiving bids from 4 different vendors. I know how to calculate total min spend and show which vendor to utilize for each item. Say I want to only set up purchase agreements with only 2 vendors. How can I...

I have a combobox list that I populate with Private Sub UserForm_Initialize() Me.ComboBox1.List = [Accounts].Columns("A:B").Value End Sub the combobox has 2 columns, with the first one being bound: which works wonders as It shows me the account number and the vendor it belongs to. some account...

Below is a snippet of the code I use to send emails from excel. I would like to expand this to change the sent from based on a list of vendors. So What I think is as the email is generating it would compare the field "VND" which is the vendors name against an excel spreadsheet and change 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...

Hello Everyone This is my question I have a excel book that I have created for like a master inventory list and as I download the inventory excel books from my vendors I wanted to know is there a way for my excel book to check the vendor's file and match the SKU for a product and then...

Is there a way to protect a sheet from being viewed until a password is entered unless someone has another idea? The reason I ask is because I am wanting to have tabs for specific vendors and I do not want vendors seeing each others information. Thank you,

From a list I would like to generate combinations of n members from a set of x possibilities in Power Query. I have found some useful code here on creating combinations of members based on all possible values of n, and here on generating permutations for x, but I regret that I'm not good enough...

I have a spreadsheet that contains the following: I am checking prices between 5 different vendors: Columns D, G, J, M and P contains the Vendors Part Numbers Columns E, H, K, N and Q contains the Vendors Prices Columns F, I, L O and R contain the Vendors initials I am trying to set up a...

I have converted bank statements from PDF to Excel and now need help identifying the vendors in the line detail of the transactions. I can clean up some statements using Text to column but need help separating the vendors from the other text. Any help would be greatly appreciated. Once I have...

I am trying to edit a macro I have to open a list of PDFs. I have been reading and trying to teach myself how to code for almost a year... but I just am slow.. the current code moves any file from folder A containing x variant to the correct folder. I would like to change the code to open all...

Hello, I am not sure how I should create my table so that I can show a vendor who supplies multiple products along with their contact information. I want to create a table with my vendors in one column with their information in a single row. The problem is I don't know if I have to list the...

Hello, I'm working on building an analysis tool and have hit a bit of a roadblock. I have a data set for a list of vendors in rows and type of scope across the columns. I also have a "Preliminary" vendor in the uppermost row of values which represents a budget. Both the count of vendors and...

What is a DAX formula to count only those rows that have just one corresponding value in a column? We can pay vendors in 4 ways - EFT, and 3 types of checks. DISTINCTCOUNT() will give me all the vendors we paid by EFT if I filter by payment method but it doesn't tell me vendors who *only* paid...

I'm not quite sure how to word this but here is what I'm trying to do. I have a user form that contains a dropdown box to select specific vendors. I would like the corresponding data to populate from that row to into the other text boxes within the form. the issue that I have is that I'm not...

Is it possible to have a formula or VBA to display a dynamic stacked chart? I have the data and the chart already created, just looking to see if this is possible. The chart shows the number of vendors and sales % for each. If another cell, let's say A1=4, then display only the 4 vendors in the...

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