vendors

  1. D

    delete record

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

    How to handle duplicate vendors

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

    Create a filter for a slicer based on if the sum of values is not equal to zero when a timeline changes

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

    Analyzing Bid Results controlling for number of vendors

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

    Userform Combobox, only include rows where column x = value

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

    Swapping email accounts on send

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

    FIFO from multiple vendors

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

    Auto Updating from excell book to book

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

    Protecting Sheet

    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,
  10. M

    Generate combinatorials in Power Query

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

    How to find Minimum Value between Several Columns and return Corresponding Company Name??

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

    Identifying vendor in bank statement line detail

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

    VBA open PDF from range with wildcard

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

    Vendors who supply multiple products

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

    Solve for Min Sum and Full Scope

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

    Count only unique rows with a single matching value

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

    how to autofill Textboxes based on Dropdown box selection

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

    Formula/VBA to determine and display stacked chart

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

    Maintain the same chart colors for a Vendor when selecting different slicers?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top