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.
