Hi Sudhir, Would it be possible for you to attach both the sheets, i will try to work on it.
If possible, please specify which sheet would serve as the master against which the other sheet will be compared. Cheers! Harry On Tue, Apr 27, 2010 at 9:25 PM, sudhir kumar <sudhir.p...@gmail.com> wrote: > Thanks Harpreetji, for your valuable solution > I have an another problem, > I have two excel sheets, both are having same format, and > contain huge > amount of data. > now i want to compare them, old one with the new one. and i want to > find out which data is deleted, which one is added, and which one is > changed. plz help me. > > Thanks..... > > On Sun, Apr 25, 2010 at 9:58 AM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> Hi Sudhir, >> >> I think you are looking for "How to group rows and columns?". >> >> Please find attached some information sourced from the net, i think this >> will give you complete details about it. >> >> Cheers! >> >> Harry >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 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 >> > > > > -- > Regards- > Sudhir Kumar > Design Engineer, > Conceptia Software Technologies Pvt. Ltd. > Email id-sudhir.p...@gmail.com, > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 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
