supplier

  1. P

    Return a Suppler name from a text string

    Hi, thanks for looking? When I download some nominal data from the finance systeminto excel the supplier number (which is a mixture of letters and numbers) appearseither at the start, middle or the end of a text string including otherinformation. Therefore if I am wanting to do a vlookup against...
  2. N

    Update a combo box

    Hello, I have a userform with some comboboxes and commendbuttons, one of the comboboxes named "cmb_Name" In Sub UserForm_Initialize, I have below peace of code to show the suppliers names in the combobox Dim rngName As Range Dim ws As Worksheet Set ws = Sheet8 For Each rngName In...
  3. H

    Excel vlookup with variable information

    Helloooo, Is there a way please to lookup information from other spreadsheets based on variable information? This is quite hard to explain so I’m just going to list out what I have below and hope that someone can make sense of what I am trying to ask! So this is a little mock up of my scenario...
  4. K

    Multiple emails with each row data

    Dear All, I have this excel data where am trying to send individual email along with the data from each row associated to that email id. Below is the format <colgroup><col span="6"><col><col span="7"></colgroup><tbody> Number BU Amount Currency Supplier Name Creation Date Invoice Date Status...
  5. N

    How to split multiple worksheets of data by column value and output to separate files?

    I have an Excel 2010 workbook (let's call it 'Master') with many worksheets, whatever name. Each worksheet has data structured as shown below. One of the columns has an identifier, such as a supplier code. Both sheets on the Master are sorted on Column1_header. Note: The actual structure is...
  6. P

    Matching and listing

    Good day Firstly, I am very grateful for the help I received last time round. Whoever helped me thank you. I had a mail glitch so I cannot do it personally. I am trying to help my wife with managing a ******* etc I have managed to construct some stuff but now I am struggling to extract the data...
  7. M

    Access Query via VBA

    I need to return some access records where a field doesn't contain two specific text strings. I am using the following to build the querystrQuery = "SELECT InvDate, Agent, BoxRef, Supplier, Invoice FROM SageData WHERE (Supplier Not Like '*CNG*' AND Supplier Not Like '*Swalec*') AND InvDate = #"...
  8. M

    Summary tab colours

    Hello all, i was kindly helped with a vba code today, which worked great, but i've come across another issue. i have a summary sheet with a list of suppliers, which all have their own tabs. i wanted the suppliers in the summary sheet to match the colour of the sheet tabs. my problem is when...
  9. T

    Complex Conditional Formatting

    Hi all :nya: First time poster, great to be here! I've always been a big fan of Excel ;) I'm wondering if you could help me with a requirement I have please. We have two columns, one is our part number, and another is a supplier's part number: <tbody> Our Part Number Supplier's Part Number...
  10. P

    Search results Multiple Rows

    Hi, I'd really appreciate if you can please help me construct the formula needed to bring multiple results from many rows. (I know that a regular VLOOKUP will only bring the first result but here it's possible that there will be up to 6 required results). I received a file "Current", which lists...
  11. C

    If range values exist in cell, then... how?

    Hi, Sheet 1/Column A: Invoice description + supplier name Sheet 2/Column A: Supplier list If any of the names in the supplier list (range) match with the (cell) value in column A, I want that to retrieve that name to Sheet 1/Column B. The opposite would be much easier but the problem is that...
  12. C

    summarise one sheet and have results sent to a second worksheet

    Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance, Sheet 1 “Supplier...
  13. C

    Consolidate on Time Delivery for each supplier and pull results into a different spread sheet

    <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I...
  14. H

    Returning Filtered results

    Hi All, i am trying to find a a function that can filter a column of supplier codes (the column will have the supplier code in it between 1-??? times) then return it on a new sheet just once along with the supplier description (adjacent cell) eg: the source sheet <tbody> <tbody> 20935...
  15. A

    match index vlookup

    I have a sku that i want to look up in a range and i want the find the amount of a certain supplier attached to that sku in the range, Does anyone know how to do this
  16. Grizlore

    Populating items in a ComboBox

    Hi All, I am trying to automatically pick up a selectable list of supplier names into a userform ComboBox and i am a little stuck I have several hundred supplier names in a worksheet called "Supplier List" and I would like to be able to select one of these in the Userform. As there is so...
  17. C

    Dependent list with tables

    Thanks for your help. I have a number of Suppliers and I have listed the products they supply under the Customer name. I want to be able to choose a Supplier and have the output generate the list of products for the Supplier. I would also like to get the output to display 2 other features: a)...
  18. G

    Costings using VLOOKUP based on multiple dropdown options

    Hi all, New to the forum and my Excel skills need a bit of work! Hoping someone might be able to help please? I am currently creating a costing spreadsheet - each tab/worksheet relates to a specific supplier and contains the items they sell and their prices. I'd like to create a front sheet...
  19. L

    Moving cells and creating columns according to a criteria in another cell

    Hi friends, :biggrin: I have to create a macro (or a formula) to do the following: I need to get the supplier name when it appears on the below cell and transport to the same cell of the part number, adding new columns for them. Column A --> is a structure index (not really important here)...
  20. Shazz

    VLookUP Formula

    Hi All, I want to be able to click on a Supplier in the drop down menu on the PO Tab and all the address details are pulled through onto the cells under the supplier name, I know this is possible but I cant work out how to do this. I do not have an option to upload an example but I can PM one...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top