Sudhir, I am sorry, but i did not get your point.
Even if you add a row in between the data, it will analyse data upto Row 200/ or more if you plan to do so One presumption is that the data will not be repeated i.e. Compartment Name will not repeat. Let me know, if you face further problems Harry On Apr 30, 8:04 pm, sudhir kumar <sudhir.p...@gmail.com> wrote: > Thanxs dear for spread sheet compare, > there is a problem with this if we add a new row in between two rows than,it > will take all the data in rows below newly added one as a changed in data. > hw can i short out this problem. > thanks. > > > > > > On Wed, Apr 28, 2010 at 5:48 PM, Tom Jeffries <tjeff...@gmail.com> wrote: > > There is an excellent spreadsheet compare addin you can upload from > >http://sourceforge.net/projects/spreadshcompare/ > > It can easily do what you want. > > > On Tue, Apr 27, 2010 at 10:51 AM, sudhir <sudhir.p...@gmail.com> wrote: > > >> Dear friends , i m waiting for reply, > >> thanks > > >> On Apr 26, 8:59 pm, sudhir <sudhir.p...@gmail.com> wrote: > >> > Dear friends, > >> > 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. > > >> > -- > > >> ---------------------------------------------------------------------------------- > >> > 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 athttp://www.excel-macros.blogspot.com > >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> > 5. Excel Tips and Tricks athttp://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 athttp:// > >> groups.google.com/group/excel-macros/subscribe > > >> -- > > >> ---------------------------------------------------------------------------------- > >> 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 athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://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 > > > -- > > > ---------------------------------------------------------------------------------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://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 > athttp://groups.google.com/group/excel-macros/subscribe- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
