hi i try creating a macro to transfer data from one sheet to another but the
pasting is becoming tricky to me. i want to be able paste more than one row
or just one row depending on the data enterd in the transfer area. my macro
is using the relative ref and it paste the first 4 rows i selected correct
but when i used one row it not right

i will like to paste either more or less rows but it should always go to the
next available row thanks