dear harpreet, i m not having a great knowledge of vba, so can u help me hw can i use the code send by u, i already pasted that code into a module, but hw i run that code. thanks
On Sat, May 1, 2010 at 5:33 PM, sudhir kumar <sudhir.p...@gmail.com> wrote: > Thanxs dear., > i 'll try this , if i will tell u if i get nay problem > thanxs > god bless u > > > On Sat, May 1, 2010 at 9:35 AM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> 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 >> > > > > -- > Regards- > Sudhir Kumar > Design Engineer, > Conceptia Software Technologies Pvt. Ltd. > Email id-sudhir.p...@gmail.com, > > -- 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
