• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Workers bed-space allotment in Excel.

    Hi 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...
  2. A

    Find the first value and display the adjacent cells values.

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

    Find the first value and display the adjacent cells values.

    Hi 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. Example 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...
  4. A

    Worksheet_Change procedure to generate few rows of data

    I have posted the same question in another forum too. this is for all your information. https://www.mrexcel.com/board/threads/worksheet_change-procedure-to-generate-few-rows-of-data.1174311/
  5. A

    Worksheet_Change procedure to generate few rows of data

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

    Production batch card with different part for one product.

    Need to remove it. Please don’t consider that column. Instead I will insert SL No in before column A.
  7. A

    Missing value indication in SUMPRODUCT

    Thanks a lot Bosco! It is working perfectly.
  8. A

    Missing value indication in SUMPRODUCT

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

    Production batch card with different part for one product.

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

    Missing value indication in SUMPRODUCT

    Hi 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...
  11. A

    Production batch card with different part for one product.

    Thanks, Marc L It is working fine now.
  12. A

    Production batch card with different part for one product.

    Dear Marc L Thanks for your code. I will take care of the row height and sum values. Once again thanks for all your support.
  13. A

    Production batch card with different part for one product.

    Boss, ~Awesome~ 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...
  14. A

    Production batch card with different part for one product.

    Also, The rows in the batch card sheet to be adjusted according to the products parts. Eg If only one part with 6 RM then 6 rows required If 4 parts with 15 Rm then 15 Rows required.
  15. A

    Production batch card with different part for one product.

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

    Production batch card with different part for one product.

    Dear Marc L I will continue with the manual batch card for the time being. Thanks for your support.
  17. A

    Production batch card with different part for one product.

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

    Production batch card with different part for one product.

    Thanks for your reply. I will try to make the file and share the same.
  19. A

    Production batch card with different part for one product.

    Boss, 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...
  20. A

    Lookup between days

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

    Production batch card with different part for one product.

    The Batch card partwise.xlsm have the new products which consist of 2, 3 and 4 components in one finished product. Eg 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...
  22. A

    Production batch card with different part for one product.

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

    Production batch card with different part for one product.

    Hi 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...
  24. A

    SUM by colour is not giving correct results

    Yes, Thanks. Well Noted.
Top