I have an input TABLE that records equipment hours and fuel usage. The daily data entries get sorted and copied to a separate DATA table located on a different sheet (same workbook) using the Autofilter Function. The input table has a BEFORE METER READING and an ENDING METER READING. Once the VBA has transferred the data to the separate datasheet, I need to reset the meter readings. The ENDING METER READING becomes the BEFORE METER READING for the next day or reading occurrence.
The problem I am having is that I can not figure out how to move the CURRENT METER READING to the BEFORE METER READING to the items only affected by the Autofilter Function.
Bookmarks