Hi Koneng, Explaing with steps would be more understandable.
Regards, Lalit Mohan On Friday, 28 December 2012 09:36:24 UTC+5:30, Bhaity Koneng wrote: > > Dear All Experts, > > Gud mrng..!! any Solution for this ? > > > > > > > Thanks & Regards, > Koneng > > > On Thu, Dec 27, 2012 at 2:42 PM, Bhaity Koneng > <bhaity...@gmail.com<javascript:> > > wrote: > >> Hi Hilary / Prince Sir, >> In the excel sheet, if you see in sheet2, then NH No, Name of the >> section.......and Car tye. In car type i have :- >> Car/Jeep/Van Single Entry Car/Jeep/Van Multiple Entry Car/Jeep/Van >> Reusage >> of Multiple Entry Car/Jeep/Van Reusages of Monthly Passes >> Car/Jeep/Van Exempt >> .. >> Again we have for LCV, TRUCK/BUS, HCM/EME, .....so on >> Same like above for LCV, Truck/Bus..... >> >> Now , i want all the column wise into row wise to make easier for pivot >> table. like in the sheet1. please refer sheet 1. >> i have done for -Manor- Dahisar. by copy and paste. >> >> i am not aware of that how to do. Ok any way if i am unable to >> explain you all then very frankly tell you all expert that i want the >> counts of vehicle wise by year or month. i have attached the file and i >> want pivot table like sheet provided. but it is very difficult for me to to >> do by one by one. >> >> Thanks for the revert. >> >> >> Thanks & Regards, >> Koneng >> >> >> >> >> >> >> >> On Thu, Dec 27, 2012 at 1:18 PM, Bhaity Koneng >> <bhaity...@gmail.com<javascript:> >> > wrote: >> >>> Hi experts, >>> >>> it is my first post and here i have attached a excel which i am >>> doing manaully copy and past. and it took me time of 6 hours. i have >>> another 100 to do , i have cmpleted just only 3 and it took me 6 hours. i >>> dont know how to complete that, if i do manually it will take 4-5 months to >>> complete that. >>> Any advice or suggestions how to do this a bit quicker than me. >>> >>> Thank you Gurus and please advice me some more tips to learn and have >>> ideas in excel. >>> >>> >>> Regards, >>> Koneng >>> >>> -- >>> 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 post to this group, send email to excel-...@googlegroups.com<javascript:> >>> . >>> To unsubscribe from this group, send email to >>> excel-macros...@googlegroups.com <javascript:>. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> >>> >>> >> >> > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
