supplier

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

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

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

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

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

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

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 = #"...

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

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

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

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

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

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

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

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

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

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

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

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

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