Hi Praveen, Thanks for the effort. I still need to incorporate the count of number of deposits. Regards
_____ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of kvc praveen kumar Sent: Thursday, January 07, 2010 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help needed Hi Robin, I did not get exactly what you require as i dont understand Finance much. But I created a pivot table as per your requirement in sheet3. I hope it helps. Please check and let me know. Regards, Praveen On Thu, Jan 7, 2010 at 3:11 PM, Robinson Boreh <rbo...@gmail.com> wrote: Hi guyz, Thanks for the good work you are doing. Am elated to have joined this group and again cheers to you all. All that aside I need your assistance. I need to have a report with the columns and rows as follows Range Type of Deposit Number of deposits Amount Less than 50,000 50,000 - 100,000 100,001 - 500,000 500,001-1,000,000 Over 1,000,00 Attached, please find the data in excel. Regards Robinson Boreh, Finanace Department, Upper Hill, Tel: 2874243, 0711019243 Fax: 2719705 -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
