materials

Hi There, I am in need of help. I have been working on this issue for quite some time and I am just not experienced enough in Programming with VBA to complete my task. I have to merge 2 worksheets together in one workbook. The first sheet is a Bill of Materials - Titled BOM - Sheet 1 the...

Hi, Sheet 1 (Named as Imports): <tbody> Column A ........ ........ ........ ...... Column G Material name Arrival date </tbody> Sheet 2 (Named as To dos): Column D I need Name of materials (arriving within in next 30 days) with their arrival date in column D of sheet 2...

Hey, I'm a beginner at excel but I was tasked with refurbishing our budget template. It's a construction company and in the budget we describe what we're doing and what materials we use and price it by units, square meters etc.. The thing is we use a lot of materials, and looking them up by...

Hello, I have the following code and I would expect it to only paste from B18 downwards but it is going higher. Dim wsFor Each ws In Sheets(Array("Consumer Discretionary", "Consumer Staples", "Energy", "Banks", "Financials excl Banks", "Healthcare", "Industrials", "IT", "Materials", _ "Real...

I'm thinking about taking the MS advanced Excel exam so I can add this to my resume. Does anyone know what is the best study materials to get to study for the exam? Is there a website i could go to for exam dates and times? Thank you, Michael

I have a summary Sheet in a workbook and I want to summarize the count of materials on each sheet. How can I write a formula that will use the Sheet name in Column C and return a count of materials in Column D. <tbody> C Column D Column Sheet Name Count of Materials sheet 1 10 sheet 2...

Hi, I want to make an Excek-system in a certain format. However, I have some problems making it. I hope the experts on this site can help me solve the problem. (possibly using VBA). The right material has to be found automatically and the right price must be calculated according the use of the...

I have a bill of materials and i want to know if there is a formula to get the values in column 'Cost'. (highlighted yellow cells) What i am trying to do is get a roll up cost for a part based on the level they are on. If there are sub components that make that part then the extended cost of...