Copy from one sheet to another?

[mercmannick]

:yes hi,

have a macro at moment that updates a sheet as i want it ,

i would like to add a part inside this macro that will copy from one sheet and paste to another ie: sheet2 from sheet1 ,i know how to make that happen in code but....................

how do i make it paste it into next available line if a1,a2,a3 has data to paste into a4 etc etc

Thanks in advance

Merc

[mdmackillop]

Something like this should do the trick



Sub MoveCopy()
Selection.Copy
Sheets("Sheet2").Activate
Range("A65536").End(xlUp).Offset(1).Activate
ActiveSheet.Paste
End Sub

[Justinlabenne]

I am too tired too be posting.

[mercmannick]

will that paste into next available row ?


mdmackillop (http://www.vbaexpress.com/forum/member.php?u=87) vbmenu_register("postmenu_34524", true);


Regards

Merc

[Bob Phillips]

will that paste into next available row ?

mdmackillop (http://www.vbaexpress.com/forum/member.php?u=87) vbmenu_register("postmenu_34524", true);

Try it and see!

(Hint: yes)

[Justinlabenne]

Yes, it will copy whatever cells you have selected into the next available row in sheet 2.

[mercmannick]

thanx guys