Dear Mandeep Baluja ji, Pls find the below mail and help me urgent basis.
In my first mail, I am only wrongly mentioned 5rows. Regards Kannan V -----Original Message----- From: "Kannan V" <vt_kan...@camsonline.com> Sent: β10-β07-β2015 03:29 PM To: "rockerna...@gmail.com" <rockerna...@gmail.com> Cc: "kannan.ex...@gmail.com" <kannan.ex...@gmail.com> Subject: Automatically Generating Report - URGENT Hi Bro, Really thanks for your effect, Now its working, But I am not asking this type. I will explain you now clearly, Example: 1. When "CODE" column have "k01v" means, we need only one row. (TOTAL ONE ROW) 2. Then "SLAB" column have "1" and "2" means, we need two rows. "1" for first row & "2" for second row. And scheme code also in two rows. (TOTAL TWO ROWS) 3. Then "LOCATION" column have T and B means, we need four rows. Because "SLAB" column already have two rows. So now we want to put "1" and "2" for "T" (two rows) and another "1" and "2" for "B" (two rows). (TOTAL FOUR ROWS) 4. Then "Type" column have Normal and SIP means, we need eight rows. Four rows for "NORMAL" and another four rows for "SIP". (TOTAL EIGHT ROWS) 5. Then " STEP" column have Step-1 means, we need same eight column only, Because there is only one "STEP-1". Requirement:- S NOCODESLABLOCATIONTYPESTEP 1k01v1 & 2T & BNormal & SipSTEP - 1 Result want to come mentioned below:- S NOCODESLABLOCATIONTYPESTEP 1k01v1TNORMALSTEP - 1 2k01v2TNORMALSTEP - 1 3k01v1BNORMALSTEP - 1 4k01v2BNORMALSTEP - 1 1k01v1TSIPSTEP - 1 2k01v2TSIPSTEP - 1 3k01v1BSIPSTEP - 1 4k01v2BSIPSTEP - 1 Regards Kannan V 8148746107 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? Itβs =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
