Macro for data validation

[szczypek03]

Hi guys!

I'm looking for a macro which is going to validate the data based on variables given. I have on sheet with two columns, each containing different data: id number and discount rate. In an external file is the place where data from previous file are copied. The procedure is as following: You open file1, copy the data from column 1&2, paste it into column 1&2 in file2 and get the result in column 3 based on the pasted values(ok/not ok - simple IF formula). I need macro that is going to choose and open the file2, copy the values form file1 to file2 and then mark the entries in column 2 of file1 if they are ok/not ok

Thanks for help!

[Bernie Deitrick]

Why not put the sheets together into one workbook - anyway, try this code in file2, and run it, choosing file1 when the dialog appears: This will fill the cells of column 2 with color based on OK Not OK...

Please Login or Register  to view this content.