Incrementing Daily sales by one day

[mikajake]

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....

 

[NotASuperGenius]

I use the following macro to copy the results of a xl Web query to the first empty row, starting at column b, of a worksheet. I think the part you want is

>Range("b65536").End(xlUp).Offset(1).Select

---macro---

Sub TotalSendTo()
'
' SendTo Macro
'
'

'
Range("C6:C18").Select
Selection.Copy
Sheets("Total Data").Select
Range("b65536").End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Web Query").Select
Range("C2").Select
End Sub