comparing two data set VBA

[rd1980]

I have excel 2013, and I have two different worksheets, one the Laboratory data and the other the detection limits (same number of rows and columns). I am going to compare the Lab data with the detection limits and have the results in the third worksheet. if the lab data is greater than the detection limit, copy the lab data to the same cell in the third worksheet. If the lab result is less than detection limit, show that the data is less than the detection limits by typing, for example: <0.0005.

Thanks

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic