Even if you make manual arrangement before clicking pivot table? At my vba coding level, it's quite a long code. If you manually re-arrange your data (maybe using a macro) and use a pivot table you may generate a report that will more or less look like what you want. You can also use calculated fields at some point. And last, a pivot table should be a lot more flexible than a macro.
On Wednesday, July 25, 2012 8:20:39 AM UTC+1, prkhan56 wrote: > > Hello, > With the present data, I cannot. > That is what I will do when I get all the Emp details in a summary sheet. > Now the Emp names are in columns. > I wish to have their details one below other so I can use it in a Pivot > Table > > On Wednesday, July 25, 2012 12:53:20 AM UTC+4, bpascal123 wrote: > >> Have you tried managing your data with a pivot table? >> > -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
