Hi,
on 'sheet 1' I have several lines of data which is added to all the time.
What I want to do is select all the last data entered and paste this into
seperate cells on a seperate sheet.
eg
the last data entered on sheet 1 is held from cells b1-b10
I want to take the data from cell b1 and paste this into 'sheet2' cell ref
d30, then the data from b2 on sheet 1 into cell ref f23 on sheet 2, and so on.
Once all my selected data has been pasted into my new sheet I wish then to
print it on my selected printer,
can this be done in VB, if so how
many thanks