copy cell other sheet

[kalpeshpatel]

i need to solve my problem please


I use only A1: C4 cell to enter data ,

now my problem when i click command button how to copy cell range A2 : C4 when every time i enter data in above cell range look example like below


sheet 1


A1 B2 C3

RollNo Name Grade

51 vipul c

52 Jigar a

53 viral b


sheet 2 contain following heading


A1 B1 C1

Roll No Name Grade


now, sheet 1 range A2:C4 will copy & paste in sheet 2 below given heading like A2:C4 when i click command button on sheet 1 &


agin i enter new data in sheet 1 cell range A2 :C4 it will be copy & paste in sheet 2 in exact below in earlier paste cell (sheet 2) A5: C7


please give vba code or macro

 

[SirJB7]

Hi, kalpeshpatel!


This seems to be a cross-posting of another you started last month.

http://chandoo.org/forums/topic/copy-cell-in-other-sheet


If it is, I suppose you've read the 4th sticky topic at the forum main page, specially in the cross-posting section.

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


By the way, did you checked out prasaddn suggestion? Didn't it work for you?


Regards!