materials

  1. E

    Merging 2 Reports together

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

    Pull values of a column of one sheet based on dates

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

    What's the best approach here? (Data Acquisition)

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

    Macro is pasting over data

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

    Excel Certification

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

    Need to sumarize the count of materials on a Summary sheet

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

    FIFO-system

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

    Bill Of Materials

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

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top