mercmannick
07-13-2005, 12:25 PM
: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
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