Comparing Files from Week to Week

**Ziggyed** · 02-05-2009, 08:23 PM

I have to download a report every week and have been manually checking the report weekly for changes. Need help in creating a formula that will help me find the changes?

Thanks
Ziggyed

**[email protected]** · 02-05-2009, 08:58 PM

S,up, Ziggy.

Are you importing the weekly data into the same workbook each week for comparison purposes, or are you just comparing the two open workbooks?

I'm sure it's easy to compare using a formula, but we really need more information to be able to help. Perhaps if you upload a sample workbook.

Hutch

**Ziggyed** · 02-05-2009, 11:07 PM

I am comparing two open workbook. Each week, I download the information into a new worksheet and them compare the two reports for any changes.

Sample of Information

In columns A, B C)

Number Title Address
4578932 Baby Bear 1 HOUSTON, TX
4539276 Baby Bear 2 HOUSTON, TX
4863214 Baby Bear 3 HOUSTON, TX
5655461 Larry Boy 1 HOUSTON, TX
5797602 Larry Boy 2 HOUSTON, TX
5939743 Larry Boy 3 HOUSTON, TX
6081884 Larry Boy 4 HOUSTON, TX

Thanks

**Ziggyed** · 02-07-2009, 11:50 PM

Thank you NBVC...I found my answer in the respond you gave to dellf on 1/29/09. DELLF asked the question on "checking and indicating data from sheet to another"...this solves my problem.

Thank you

**Ziggyed** · 02-08-2009, 12:28 AM

Problem solved

**VBA Noob** · 02-08-2009, 06:43 AM

I've marked it solved for you this time but below is how you did it yourself

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

VBA Noob