Automatically transfer data from sheet to sheet


I am working to transfer data from sheet 1 to sheet 2. I created a macro to perform the task which was easy enough but when I transfer the next set of data to sheet 2 the information overwrites the initial data transferred, 

How do I increment to the next line of sheet 2 so I donot overwrite the initial data transferred when I ran the macro.

0 Replies