Hi Experts,
I need your assistance to solve this.. I'm trying to compare two different sheets( Sheet 1 and Sheet 2), and if the data in sheet 1 difference is more than 500, I want the macro to check why is it different against Sheet 1 data and copy paste the details to sheet 3
Conditions that to include is check the attached excel workbook)
1 - if Shanan "Net pay " in sheet 2 more than 500 in Shanan's "Net pay" in sheet 1, check why is different is it because of allowance or overtime ( to compare against sheet 1's allowance and overtime details) and employee name and reason for difference in sheet 3
2. If shanan have more than 1 line of net pay in sheet 1 or sheet 2, plus all values before start the comparisons.
Thanks guys, Have a great day ahead
I need your assistance to solve this.. I'm trying to compare two different sheets( Sheet 1 and Sheet 2), and if the data in sheet 1 difference is more than 500, I want the macro to check why is it different against Sheet 1 data and copy paste the details to sheet 3
Conditions that to include is check the attached excel workbook)
1 - if Shanan "Net pay " in sheet 2 more than 500 in Shanan's "Net pay" in sheet 1, check why is different is it because of allowance or overtime ( to compare against sheet 1's allowance and overtime details) and employee name and reason for difference in sheet 3
2. If shanan have more than 1 line of net pay in sheet 1 or sheet 2, plus all values before start the comparisons.
Thanks guys, Have a great day ahead