Prev: Installing old Active-X Controls in Windows 7-64
Next: Run Time Error 1004
From: Al on 12 Jul 2010 16:06

Dear All:

I get excel sheet on monthy basis . and i am trying to provide a
summary of differences(new rows, deleted rows and changed) between the
present excel sheet
and the one i got a month earlier .

can this is achieved .. ?

Thanks in advance
Al
From: Tim Rude on 12 Jul 2010 16:37
Not sure this is Visual Basic related, but you could export each sheet to a
CSV file and then use a text comparison utility (of which there are plenty
around the 'net) to compare the CSV files.

Of course, if you need to do more than just see the basic data (i.e. you
need some polished comparison sheet), the CSV approach isn't for you. In
that case, try this:

http://www.lmgtfy.com/?q=compare excel worksheets

"Al" <ali6058(a)gmail.com> wrote in message
news:ada57ec0-15a0-4d9e-8e37-b712ea09dd6a(a)j8g2000yqd.googlegroups.com...
>
> Dear All:
>
> I get excel sheet on monthy basis . and i am trying to provide a
> summary of differences(new rows, deleted rows and changed) between the
> present excel sheet
> and the one i got a month earlier .
>
> can this is achieved .. ?
>
> Thanks in advance
> Al

From: Tim Rude on 12 Jul 2010 16:40
Oops. Try this link instead...

http://www.lmgtfy.com/?q=compare+excel+worksheets

"Tim Rude" <timrude.nospam(a)nospam.hotmail.com> wrote in message
news:i1fudp$d04$1(a)news.eternal-september.org...
> Not sure this is Visual Basic related, but you could export each sheet to
> a CSV file and then use a text comparison utility (of which there are
> plenty around the 'net) to compare the CSV files.
>
> Of course, if you need to do more than just see the basic data (i.e. you
> need some polished comparison sheet), the CSV approach isn't for you. In
> that case, try this:
>
> http://www.lmgtfy.com/?q=compare excel worksheets
>
> "Al" <ali6058(a)gmail.com> wrote in message
> news:ada57ec0-15a0-4d9e-8e37-b712ea09dd6a(a)j8g2000yqd.googlegroups.com...
>>
>> Dear All:
>>
>> I get excel sheet on monthy basis . and i am trying to provide a
>> summary of differences(new rows, deleted rows and changed) between the
>> present excel sheet
>> and the one i got a month earlier .
>>
>> can this is achieved .. ?
>>
>> Thanks in advance
>> Al
>

 | 
Pages: 1
Prev: Installing old Active-X Controls in Windows 7-64
Next: Run Time Error 1004