Find and Sort out the rows with particular value

[Viswateja]

Dear All,

Please have a look into the file attached with this thread. In the "Input Sheet", I have a table of values. In column "G", one can find comma separated values (not exactly comma separated, there might be additional spaces too in between). So, I need to find out all the rows consisting of a "particular value (shown in red font as an example)" from the "G" column of "Input Sheet" and they should be printed in the "Output Sheet" in the given format. This process has to be repeated for all 'distinct' comma separated values in column "G". If I start doing it manually, I knew it would be taxing, so I wanna reduce the effort with any macro. Any reply would be appreciated.

[JOHN H. DAVIS]

I can't open your attachment?

[jindon]

Please Login or Register  to view this content.

[Viswateja]

Dear Jindon,

Thank you so much for your immediate response. But what I have intended is not only for the "red font" items in "Input Sheet", but this sorting shall be done for every individual entry in the "G" column. And the rows shall be printed for every individual entry. Hope I made my point clear.

[jindon]

Please Login or Register  to view this content.

[Viswateja]

Dear Mr.Jindon,

Thank you so much for your help. But I found some issue after exceuting your code in a new file. I am attaching here by the file "GTG Building", where I have inputs in "Input Sheet" and the output of the executed code is in "Output Sheet". If you take a close look of a row which I have highlighted in "Red" font, that particular row is filtered under "31MBA005/3", but there is no such value in "G" column of that row. I am not sure if there are minor glitches as such in the other filtered values or not. I would like to request you to please go through this issue and help me out with the corrected vba, if any mistake is found. Awaiting reply.

[jindon]

See if this is how you wanted.

Please Login or Register  to view this content.

[Viswateja]

Dear Jindon,

Hopefull this solves the problem. You are a saviour. Thank you so much for prompt reply. Sorry to bother you, as I have some more work to be done with the same file.
I have generated the output wiht the vba code that you have written. Now, in the output sheet, adjacent to every "Yellow" cell, I want to have a "Blue" cell, where I can have an option to enter any value. I have shown an example in the attached file. I have entered "600" in the blue cell. Then I have to generate the cross sectional area in Column "O" (in Orange colour), taking the value in column "K" as the diameter. I have written the formula for the same within the cell for your perusal. This process has to be carried out for all the diameters (rows) that comes under that particular "Yellow" cell. Now, column "P" shall have a merged cell, which gives the (total sum of area of all the cells under column "O")/(value in the blue colour cell) in a single merged cell, which is shown in "Green" Colour. You will have a clear idea once you go through the "Output" Sheet. This process has to be repeated for all rows under individual "Yellow" cell. Appreciate your reply, if any doubts are there.
Thanks