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

Recent content by Anbuselvam K

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