Search results

Dear Excel Guru, I need a VBA code to add a new worksheet with respect to the selected columns filtered list. The attached file has some data of rows with a data filter. If I select any of the filters and run the code, then it should add the list of the new sheets with it is selected list...

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

Thanks a lot @ bosco_yip

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

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

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/

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

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

Thanks a lot Bosco! It is working perfectly.

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

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

Thanks, Marc L It is working fine now.

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.

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

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.

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 I will continue with the manual batch card for the time being. Thanks for your support.

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

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

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

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

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

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