Hi. I have a row on a worksheet that displays the current date (=today()). I need the data in that row , beginning with the next column to move up to the row above it (=today()-1) when the current day changes. This is to keep a rolling count of current inventory. Any ideas?