I update vehicle mileage on a monthly basis and need a macro to populate a yearly page by month
mileage sheet has odometer in column K and dates in column O, the date changes everytime I update the mileage
I need to populate the yearly sheet according to the corresponding month, so if I update in Feb it should place odom reading in February column on yearly page, when I update in March put same in March column of yearly.
Any help is appreciated
Thanks
Bookmarks