Hi. I just received a project to work on and need lots of help. I need to create a marco using visual basic to be used in excel. I have never used VB so I am not sure what I am doing.
We have an excel book with two worksheets that are basically the same; its the information for each months billing. So there is an ID in column A and then the different options they are signed up for in columns like B-N.
What I need to do is have a macro that first checks the ID in sheet 2 and checks for it in sheet 1. If it finds it in sheet 1, then it needs to compare the rest of the values in that row and see if there is differences, and needs to highlite them. Or if there is no change, then it can just leave it the way it is.
But if a new ID is added in the current month (sheet 2) then it will not be in sheet 1 (previous month). So in that case it would have to highlite the whole row to knot its a new ID and all billing options are new
I hope this description makes sense…but if you can help me out that would be awesome. Like I said, I have not used VB before so this is a complicated task for me. Thanks for your help