I need formulas to check the bed-space available and allot to the new workers in Excel.
Attached excel sheet has
A1 to A7, B1 to B7.... F1 to F7 are Rooms for Workers (Each Room has only 4 Bed-Space Available)
C1-1 to C1-23 are Contractor1 has workers 23 Numbers
C2-1 to C2-10 are...
Working well Thanks @bosco_yip
This formula extracting the first used product Name only, Is there any way to get all used products like below?
RM1 ==> Product 3, Product 6, Product 10
RM5 ==> Product 6, Product 10
The below snapshot Column A to L is the base data. The right side P column is the Input and the Q column values are the expected results.
Column C RM1 used in rows 8, 11, and 15 the product is 3, 6 10
Column J RM8 used in row 11 and 15 the product is 6 and 10
Likewise, I have...
Dear Excel Genius
I need the Worksheet_Change procedure to generate the production Batch Card from different products formulations.
The below-linked thread was created and I got the procedure. But now I have some modifications in the source data as well as output structure too...
Thanks for your reply.
Manual Example as below.
Product 2 used the RM Name of "A:D & F"
Except for RM D, all the RM have a price in row 1
Because of the missing RM price, the product cost is not correct in the cell "L4"
So it should be indicated with some difference than others.
Dear Excel Genius
I need some modifications in the code of #16 according to the below input changes.
1) In between the RM, there are some blank cells that were not there in the original file of the first post. Due to some New RM allocation, it has happened and I request you to change the...
As per the below image, I have used the SUMPRODUCT formula in the cells L3 to L13.
In the Second row some of the RM not having the prices in the first row (D, E, I, and J)
But, The formula sumproduct has given the results as usual.
I need to get the indications if the Products having...
It is working perfectly. Thanks a lot for your valuable support.
Just small things need to take care of as below.
Row heights to be fixed whenever changing the products.
Also, Specification row heights to be fixed with the same.
After completing the parts You can see two...
Dear Marc L
The below details are enough to provide the code.
parts are selected in Formulation worksheet columns F: BE by background-colour
according to 3 criteria in columns A:C with parts % in column E.
Dear Marc L
Thanks for your suggestions.
I try to find some other way instead of colours.
As far as my knowledge I explained everything I needed
But, I don't know how to make one file that will give my output by formulas or VBA code (This is what I posted here)
Anyway thanks a lot for your...
The Batch sheet old.xlsm VBA code I got someone from here in 3 to 4 years back. That time it was very excellent solution as all the products has only one part.
If that kind of code is not adequate for this new type of products which has many parts in one product, we can use any...
I hope the column D is are your expected results Right? If yes
See left side screenshot where there is no A506997 entry no for AB04CV4158...
Then how as per right side screenshot row 7 you gave entry no of A506997 to that vehicle number?
Also, the AB04CV4158 entry book first entry date is...
The Batch card partwise.xlsm have the new products which consist of 2, 3 and 4 components in one finished product.
Finished product Poxy 2k have two parts of Part-1 and Part-2
Finished product Poxy 3k have three parts of Part-1, Part-2 and Part-3
Finished product Poxy 4k have four parts of...
Dear Marc L
Firstly I would like to thank you for your response.
Here I am explaining the Batch card old.xlsm how is working then we will come to know how the new sheet to be worked.
The left screenshot of the Formulation sheet is the base data where I will add all products formulations...
I have created one batch card sheet for my regular productions as per the attached sheet Batch card old.
it is working well until the products have only one part as a below-left screenshot.
Now I have a product which is having 2, 3 and 4 parts of components in it.
So I want to change the...