material

sheet1 data: column C (material #) ; column F (salesman name) ; column G (Salesman count per material) = ? ; column H (salesman name) = ? sheet2 data: column B (salesman name) ; column F (material #) need: sheet1 , column G answer formula =COUNTIFS('New Materials'!B:B,Materials!E7,'New...

I am trying to write a formula that rounds up (or down) to the nearest whole number. Here are my parameters. This is for optimizing material lengths in manufacturing..... Cell P40 = number of stock lengths required Cell D22 = Quantity of Pcs Cell J6 = Length of Each Pc. Cell I40 = Length of...

Hi there, I need some help in terms of the code I require for prompting the user to key in the material number and using that material number as a wildcard filter to search the excel sheet and copy the values from 2 columns and copy the material numbers that contain the search term and paste...

Hi All First time poster, and very new to excel, so please be kind. :) This may be a simple question for most of you, but as I'm relatively new to everything in excel bar basic formulas, I'm struggling. Been googling this for hours and can't find an answer (or don't know how to word in...

Hello all! I need some help using VLOOKUP (or other function) to sum repeating values. Below is some data as an example. My goal is to look up the value in column 'Material' and sum the corresponding quantity for 'Material 2'. The Vlookup function works fine, except when there are repeating...

Hello! I'm working on a spreadsheet at work and my excel skills are terrible. The spreadsheet is used to log all the processed material and I want all the info regarding the material to be filled before they can sign it off with their signature. http://oi67.tinypic.com/20773a1.jpg As shown...

Hi all, I am fairly new to Access and need some help or assistance in creating what would be a Vlookup if done in excel. What i have so far is two tables within the same access database Table one name Data Table two name Costs When someone selects a certain Material Part Number i want the...

Hi The main file is uploaded - please see the link below. I have this condition, if material number of line C is 1000015445 and material number of line H is 1000027024 OR 1000027025 then these 2 can not have the same week#. I want excel to flag or highlight or give warning etc in that condition...

I am creating a bid estimating sheet. It is derived from a pricing sheet from a supplier. The estimater, will pick the materials (B1,B9,B13,B), " SS304X4, Galv, Cold Rolled, Tube" from a list. The selection will generate another list from gauges or diameter available per product. For each...

I have read many post about "Countdowns" and "Timers". None of which provide me with the correct formula or knowledge into what I am actually looking for. So I figured I would ask the question here specifically to see if I could grab some help and understanding. Back ground: This is need for...

Hi, I need to pull pricing from a table that has Material # (ColA), Date Price was change(ColB) and the price (ColC). I want to pull for material based on a date of purchase. The table referenced is not sorted by material currently as it list of chronological price changes thus it is sorted by...

Hello, My excel file is getting very heavy & opening minutes to open, due to the formula below pasted in all rows of Table6, I want to get any alternate VBA code to arrive at values using similar search criteria s. =INDEX(Table1[MARK NO./DESCRIPTION],MATCH(CONCATENATE([@[WO...

I have the following query: <tbody> Item No Item Class Dept Code Quantity 0001 Raw Material 1 50 0001 Raw Material 2 30 0002 Raw Material 3 100 0003 Raw Material 1 75 0003 Raw Material 2 100 0003 Raw Material 3 20 0004 WIP Item 4 100 0005 WIP Item 4 100 0005 WIP Item 5 175...

Have three tables: Project, materials w/qty and material cost. Project and materials have a relationship. I want to build a query where the info from these two tables can show the info and the material used will go to the material cost table find the cost of that material multiply it with the...

Hello everyone is there any good excel educational material online? For example if I wanna become an excel specialist than what do I do?

Dear All, I created new userform and added combobox. Opened excel sheet and inserted new sheet and changed name to "Materials". In the combobox properties added row source (Materials!A1:A8). I added also some material names to the "Materials" sheet in the column A. For example, A1=Book...

Hi I need help to create a macro that can add values at Column J based on Column B. For an example, if the values at Column B is between 1 until 6, the Column J should produce "min. material level". If the values at Column B between 7 until 12, the Column J should have "Material flow" and if...

Dear All, Could you please help me to create new Userform and including combobox which I can filter and select material name (material names need to be took from any excel sheet) and when I click ok then this need to be saved "account" sheet (each time need insert new row). Textbox1 will be...

Dear Sir, I have added new Userform1 and added combobox1 + label1 and textbox1 + label1. Then added command button1 (name is submit) (when you click this button it will add info to excel sheet). I want to see combobox1 as filter which including name of material and cost. When I click selected...

With recent economic and market conditions (eg. tariffs), raw material and commodity prices have fluctuated. Some, such as steel (purchased scrap), have fluctuated significantly. If I want to use a formula for raw material pricing, does anyone suggested a specific "forecast" formula. I am...