specific data selection/pasting

[Guest]

Hi,
I want to select the last row of data entered from sheet1 (which is being
added to all the time) and paste certain bits of this into another sheet.
eg
copy the data from cells A1-A10 from sheet1 (being the last data entered)and
paste the data from cell A1 into cell F35 on a second sheet, the data from A2
onto D29 on the second sheet and so on.
Once all this data has been pasted onto the second sheet I then want to
print the final copy.
Can this be done using a macro, if so any ideas to the script??
thanks

 

[Guest]

left us a little short the "and so on" part.
A1-A10 sound more like the first row or headers????
With ActiveSheet
lastrow = .Cells(Rows.Count, "A").End(xlUp).Row
sheet2.Range("f35").value = _
Range("A & lastrow").value
Sheet2.range("D29").value = _
range("A & lastrow").value
'and.so.on
end with