Storing Data in Microsoft Excel

  • Thread starter Thread starter Ben Jones
  • Start date Start date
B

Ben Jones

Hi I wonder if anyone out there would help I have excel, and I have some
data which I update daily in the spreadsheet, I would like to create a
macro, to copy all the data onto another page, and then, so that the next
day I enter new set of data and when I press the same button it copies it
all to the same page as the other data, but one row underneath (so that it
doesn't override it)

I know this can be done, but I cant remember how to do it. I did something
in VB, active.offset but that's all I can remember if there is anyone that
could help that would be brilliant

All the best

Ben Jones
 
This will copy from your source sheet a8:c to the last row the values to the
destination sheet

Sub copydaily()
With Sheets("sourcesheet")
x = .Range("a65536").End(xlUp).Row
y = Sheets("destination").Range("a65536").End(xlUp).Row
Sheets("destination").Range("a" & y & ":c" & y + x - 8).Value _
= .Range("a8:c" & x).Value
End With
End Sub
 
Back
Top