supplier

Hi all, I really hope someone can help with this so that I can finish this project and move on. I have the following code which copies data from one sheet and tries to find the matching supplier in another sheet. if it finds the supplier it pastes to the next empty row below that supplier...

Hi All I am trying to use the TRIM function in VBA but am struggling! The code which works in excel is: =TRIM(RIGHT(SUBSTITUTE(N2,"-",REPT(" ",100)),100)) when I try to use the same in VBA, I get a compile error: expected end of statement I assume that this is because of the " within the...

I am working on a purchase order form that have multiple suppliers and different prices. I already searched the forum related to what i'm doing but it seems I can't find similar case. I used data validation for my pick list and basic vlookup function to display the item and corresponding price...

Hi Guys On sheet 1 I have invoice totals input for various suppliers on various dates. They are not input in date order or supplier order but as they are taken off the pile. I need to take all that data and sort it on sheet 2 by supplier(Column B) and then date (Column D). Multiple invoices...

Good morning, I have a workbook with a number of worksheets, two of which are named "New Product or Supplier" and "Data". I currently have some code that takes cells C4 and D4 from the "New Product or Supplier" sheet and creates a table in the next empty column in the sheet "Data". I would...

I have two sheets as follows; Sheet 1 -----------------------------------------1-April----1-May---1-June---1-July....so forth -----------------------------------------30-April--31-May--30-June--31-July....so forth User ID | Supplier | Payment Type |_______|_______|_______|_______| Sheet...

Hi, I need some help creating drop down lists that narrow down as previous criteria is selected. I have a sheet containing data (that is constantly added to) with the following columns Supplier Product Colour Size Price I would like to have a drop down list containing all...

Hi, I want to create a purchase order generator system in excel, I have created a basic template and got to a stage where I'm stuck for ideas on how to proceed. Basically I want the purchase order to work in a way that, once a supplier is selected from a drop down menu, the product codes...

Hi all, I would like to create a master workbook, preferrably a spreadsheet, of the following: Part Number Quantity being quoted Price per quantity being quoted Supplier I would like to easily and visually see which supplier offers the lowest price per product as well as the quantity I must...