plant

Good day, I have a sheet with Asset Type code, Customer plant and Asset Number. The Asset Type code indicates the configuration on the machines and is not a unique number. The Customer plant is also not unique but Asset Number is unique. There can be numerous Asset numbers for one Asset Type...

Good day, I have a sheet with Asset Type code, Customer plant and Asset Number. The Asset Type code indicates the configuration on the machines and is not a unique number. The Customer plant is also not unique but Asset Number is unique. There can be numerous Asset numbers for one Asset...

Hello. I am trying to take the percentage based on plant and material number and segregate the handling units to two different plants. For example, in the information below, I want excel to look at another worksheet. if the plant and material match, plant 1 will get 20% of the total 5,801 and...

I have a template for journal entries that I need to get into a different format. Right now I'm writing formulas that are working, but I cannot drag down so I'm thinking there might be a vba solution. There are 6 columns, B:G, account, center, debit, credit, company, plant. account and center...

I have over 800 lines of data. I am trying to create a forecast for each material based on the plant. I have consumption for two years. I want the forecast to be automatic so when someone enters the plant and material, the forecast is auto populated. Currently the issue I am having is how to...

I have a single workbook with (2) sheet tabs as follows - (Plant Schedule Sheet) and (Master Plant Schedule Sheet) (Master Plant Schedule Sheet) https://imgur.com/bR68kqb (Plant Schedule Sheet) https://imgur.com/VUoAXSw What i would like it to do is that whatever number you put in column...

I have a dataset generated by an SAP report that I generate at will, multiple times per day. It varies in length, but is about 4000 rows and 60 columns wide. The columns never change but the rows do. I want to be able to drop an updated dataset into a data tab and have a number of tabs each...

Hey All, first time posting - so in advance thank you for the help in the future and in the past when I search the forum. Issue: I need to take a set of data and use text to columnsto separate out each step in a process. The steps are separated out but numbersexample (1., 2., 3. Etc), I haven’t...

I have data in 5 tabs in my spreadsheet and have created a Pivot Table from each tab. Now I want to combine the 5 Pivot Tables into 1 consolidated Pivot Table. How can I do this? Each Pivot Table is for a different Plant and contains Product Codes and its Quantity. I would like a single...

Dear Guru's Good day! Need your help on how to get the cell value (Bin Coordinate) using maximum count with reference to cell Enter Plant (ex. D301). Many thanks in advance. <colgroup><col><col><col><col></colgroup><tbody> A B C 1 Enter Plant: D301 2 BIN Coordinate ...

Is it possible to a dashboard or userform automatically open when Excel is started that contains a drop down box that filters by plant name? Based on what plant is chosen in the filter or drop down box the plant contact information is displayed? I thought about using a pivot table, but I could...

Hello everyone. I have been searching for a way to do this and don't even know the right questions to ask. I have always been able to figure things out without help, except Google, but this has me stumped. What I am trying to do is develop a plant database that will show all plants I will be...

I appreciate this is a lot of information I am just not sure how to achieve what i need, probably indexes & Macros. I have multiple workbooks, each workbook is for a plant type, each tab within the workbook is for a different size of the plant. I want to create a consolidated workbook that...