Hello!
I noticed a similar post called "Compare data in columns of two worksheets and return value if match" but, I do not quite understand it well enough to apply it to my situation.
Step 1: I created a macro to assign points for each incident that a vehicle's owner was speeding over 10 miles the speed limit in a given day and then to total the points penalized each day by vehicle.
Step 2: I need to create a macro to copy each daily point total from one worksheet into each corresponding vehicle’s daily column found in a separate worksheet. Sometimes a vehicle will not appear on the report so, a zero should appear in place of a daily point total.
Step 3 – In a third worksheet, I need to create a macro to add the points accumulated each day by each vehicle and, to subtract the points assigned 31 days ago by each vehicle. Then, next enter the total onto each vehicle's row. LGM231 is my example showing how this row's and all preceding rows' accumulations are calculated. For each vehicle not listed in Step 1's report, the macro needs to subtract a day's worth of points penalized 31 days ago.
I look forward to your response. Thank you!
Sheri
Bookmarks