Comparing Two Worksheets..Beginner in Excel

[EllieFant]

Occasionally I get an excel worksheet that has the same columns of information. (Employee Name, PSI Type, PSI Date, DA 3180 Final, CO).

I am wanting to figure out a way to find out if any of the information has changed - including new records and deleted records.

Is there a simple solution to what I want to do?

Thanks!


Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

elliefant@qwest.net

 

[MisterC]

Without completely understanding your problem, I'll take a stab at it...
> You could certainly compare each cell in the spreadsheets to see if it had changed, but that could be a real challenge to get right.
> There may be some copy/paste trick that will accomplish what you want- but I'm not sure that is the best approace either.
> I think that the easiest approach would be to import the data into Access and use the "Find Unmatched" query wizard.
That is, have one table to hold the original info and another to hold the newly imported stuff.

I'm just scratching the surface, I'm sure...
Good luck!

 

[EllieFant]

Thank you....I tried this in access and am not getting the information to come out correctly....I will keep trying.

Thanks for your help!


Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

elliefant@qwest.net

 

[VictoriaLJones]

Try searching in the Microsoft VBA forum. There are a number of entries that display how you could do this - using different methods, including some complete with code to print out a spreadsheet containing all the differences.

Victoria