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