Compare Worksheets

P

praveen_khm

Hey all,
is there any way to compare two worksheets? The limitations in the
worksheet are:
1. The cells in some columns are merged.
2. However, all the data, whether merged or not, the formated remains
the same. I meant if a1 and a2 are merged in sheet A, the same a1 and
a2 are merged in Sheet B.

Please help if there is any way to compare the worksheet.
Also am not good at script. Please specify if there is any method for
that.
Your quick response is appreciated.
Thanks,
Pravi :)
 
S

Selvarathinam

Dear Praveen,

Do you want to compare the format of both sheets or the datas of the
sheets?

Please let us know to help u.

Thanks,
Selvarathinam.
 
P

praveen_khm

Selvarathinam,

I need to compare the data of both sheets and not the format. Thank
for your kind words.

Prav
 
S

Selvarathinam

Pravi,

Use Vlookup syntax for comparing two sheets. However, upload the
sample file or provide some scenarios for the same.

This will help us to provide exact solution.

Thanks,
Selvarathinam.
 
P

praveen_khm

Thanks Selvarathinam,

I instead used vlookup and checked each column and finished it. but
please help me if known about the dropdown problem which is already
posted as a thread. However, I would repeat it.
I am recording macros and when used filters, I select it for the
present date. That is as an ex. 18th Jan 2006. Tomorrow, i ll insert a
new data and it consists of the next day, i.e, 19th January. Please
help if you have any coding or procedure which can make the macro work
such that, everyday it takes the present date or the system date. Any
quick help would be appreciated as I am in a fix and the project is
lying without any advancement.

Thanks again.
Pravi.:)
 
Top