PDA

View Full Version : Compare Workbook to 2nd workbook (Newbie)



murtmack
10-23-2009, 04:31 AM
Hi ,
Hope someone can give me some help on this problem.

Need to check that the steps invloved in a exam is completed correctly to give marks for the exam. Say someone complete exam that asks to do various tasks to see if it is done. The completed test needs to be checked against a 2nd workbook that has all the correct steps done. E.g check that cell formatting, formulas , save as different filename etc.

Does anyone know how to start this in VBA or another way.
Thank in advanced.

Murt.:help

mdmackillop
10-23-2009, 05:22 AM
Welcome to VBAX
Can you submit a sample workbook showing Exam and Results and also what you want to see after checking.
Use Manage Attachments in the Go Advance reply section to submit a workbook.

Regards MD

murtmack
10-23-2009, 06:06 AM
This is the original file on sheet 1 there are some labels and values entered into it.

murtmack
10-23-2009, 06:12 AM
This is the 2nd file where the number values are copied and put into the column heading Feburary.

This is just a basic example where want to check that the values are the same and formatted the same as the Janurary column. Need to check if it bold etc , formatted currency etc. But in this example only comparing the values.

Iam a complete newbie to all this and it would be helpful if someone could show me how to create a vba macro to do this

Thanks,
Murt.