Dear friend,
first of all thanks u very much for ur mind blowing programing,
just tell me one thing if i want to apply same concept with my some other
file having different format, than what should i do, i means different
heading, and position of text.
thanks
--
Regards-
Sudhir Kumar
Design Engine
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 wrote:
> Thanxs dear.,
> i 'll try this , if i will tell u if i get nay
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 d
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
Ha
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 wrote:
> There is
Hi Sudhir,
I hope the following code will help you out:
"Public Sub Test()
Dim W1 As Worksheet
Dim W2 As Worksheet
'Change the filw name accordingly
Set W1 = Workbooks("Old File.xls").Worksheets("Sheet1")
Set W2 = Workbooks("Latest File.xls").Worksheets("Sheet1")
For I = 2 To 200
Val1 = W2.Ce
Dear Friends ,
I m waiting for your response..
On Wed, Apr 28, 2010 at 11:05 PM, sudhir kumar wrote:
> Dear Friend,
> Thanks for your response, I attached two excel sheet here, one is 'old
> file' and other one is 'latest file'.
> Latest file is having the latest changes, now i want to compa
Dear Friend,
Thanks for your response, I attached two excel sheet here, one is 'old file'
and other one is 'latest file'.
Latest file is having the latest changes, now i want to compare both the
file so that i will come to know that what are the changes in between them,
what is added,deleted or cha
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 wrote:
> Dear friends , i m waiting for reply,
> thanks
>
> On Apr 26, 8:59 pm, sudhir wrote:
> > Dear
Sample workbook please. All formatting as origianl, and data you want compared.
Dave
> Date: Tue, 27 Apr 2010 07:51:10 -0700
> Subject: Re: $$Excel-Macros$$ How to compare two Excel sheets
> From: sudhir.p...@gmail.com
> To: excel-macros@googlegroups.com
>
> Dear friends
cel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of sudhir
Sent: Tuesday, April 27, 2010 8:21 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ How to compare two Excel sheets
Dear friends , i m waiting for reply,
thanks
On Apr 26, 8:59 pm, sudhir wro
Dear friends , i m waiting for reply,
thanks
On Apr 26, 8:59 pm, sudhir 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 o
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.
--
--
13 matches
Mail list logo
