I have a slight problem. I want to copy my daily sales data every day into a monthly spreadsheet. I have a macro that prints the daily sales. But, Each day when I add the new data, I want the monthly sheet to update and move down one row. When I try copying the data, then use End-Up, move down one row, the macro always points to "A5"
ie. 01/01/02 2536.45 245.36 245.36
new daily data.....
tomorrows data....
ie. 01/01/02 2536.45 245.36 245.36
new daily data.....
tomorrows data....