Comparing numerous sheets

Z

Zak

I do 3 different comparisons between 3 different sheets and normally use a
vlookup in each one then extract the relevant information to make a
difference report. is there not a macro i can use to reduce this comparison
process?

Thanks
 
O

Otto Moehrbach

Zak
There is no "canned" macro to do what you want. A macro would have to
be written for your particular task. The task that you describe is not
overly complex and should be easy to write. Post back and describe, in
detail, the steps you would take to accomplish what you want, if you were
doing it all manually, and ask for help in writing a macro to do it. You
will get plenty of help. HTH Otto
 
Z

Zak

Hi,

Yes i need a lot of help with writing a macro!

Basically i have a colleague here who does a report every week about new
starters/leavers on the programme etc. She does 3 different lookups to check
if the data is up to date:

-Firstly she compares what she has on her database with a report called
'leavers'.
-Then compares what she has on a SAP report with the database (everyone on
the SAP report should be on the database)
-Then compares the SAP report with the leavers report (If we have someone on
the leavers report it shouldnt appear in SAP.)

It all about making sure we have the correct information that is up to date.

Is there a code that can be written to do these checks?

thanks a lot!
 
O

Otto Moehrbach

Zak
Yes, a code can be written to do everything you say, but you haven't
said anything about what you want other than a general idea. Take pencil in
hand and write down every step you would have to take to do what you want
manually. This means detail like this column, that cell, compare this to
that, move this here and that there. The code is dumb and it has to be told
every little step in the process. HTH Otto
 
Z

Zak

Ok, i will try and note down each stage and try to write something.

Would recording a macro via the wizard be easier rather than do the code
from scratch? I did try recording it but because things like the number of
cells, amount of data etc change.. the macro becomes useless unless re-coded.
Is there a way of making the macro aware of this so that it doesnt just fall
over everytime?

thanks.
 
O

Otto Moehrbach

Record a macro like you say. When you select a range that you know will
vary later, just pick a range for the recorder and go with it. When you
post the code, detail exactly how that range has to be determined. Remember
that the people reading your post know nothing about your business. Whoever
responds to your post will modify the code accordingly. Remember that the
code is dumb and whoever writes the code has to explain everything to the
code, so provide details about how to do what you want done. HTH Otto
 
Top