adding new data to an excel worksheet

[Guest]

i have a worksheet which contains weekly data for some purchases. eash week i
get a spreadsheet with this weeks transactions. I would like to add the new
data to the exsisting data automatically. Is this possible?

 

[Guest]

Yes, it is possible with Excel VBA Programming.

*** Please do rate ***

 

[Guest]

Thanks, where do i start with the VBA Programming?

 

[Guest]

I don't know your exact requirement, but it is possible,

for instance, piece of code, which is shown below will copy from one
location to another location, automatically,

=========================================
Sub Naveen()
lstrow = Cells.SpecialCells(xlLastCell).Row
Rows("1:" & lstrow).Copy
Rows(lstrow + 1).Insert Shift:=xlDown
End Sub
=========================================

Please post your exact requirement.

*** Please do rate ***