Hello,

I am trying to write a small excel program however my VBA knowledge is so old i can't remember much and i'm struggling.

So far i have code in place that allows the user to select the CSV they wish to import and then excel will paste the information into a new worksheet. 1 worksheet for the program outputs I need to check, 1 worksheet for the master file i'm comparing it to.

I am now having a problem figuring out how to write a piece of code, that i can attach to a button press, which will take the information from each worksheet and create a list of any values that do not match.

The information from the first output looks like the example below (i don't know how to stop the c  before and after each word).

name coord-x coord-y coord-z
L12A086AMV 5319.32 -630.6 1959.44



The second "Master" file looks like the example below:

A_MP_Ten_Digit_No A_MP_Data_Sheet A_MP_Code A_MP_Alias Change_Flag Point_Level X_Coordinate Y_Coordinate Z_Coordinate

L12A086AMV LK0061 L12A086AMV_LK0061 L3 5319.32 -630.6 1959.44

I need to figure out how to create a macro that takes the name/A_MP_Ten_Digit_No and compares the X Y & Z value to make sure they match. If they do not match i need something that will highlight a list of values that are incorrect.

Cannot paste a url so its the normal start of a web site w. The below website name. normal ending com. Then the /below.

Send space . normal ending / the below data
/file/jfn43r

Above is a sendspace link to the program (in it's basic state). I have left in the outputs and master file.

Any help is greatly appreciated. I will continue to browse forums and google to try and find my answers in the mean time.

Cheers
Kris