The code is telling the last line of data but its posting it over the same line where as i would like the new data to be represented on the new row just below the old information on the previous line.
pls refer to my code below..
Sub transferdata()
Range("D4:D23").Select
Selection.Copy...
Hi,
In desparate need of help. I need to write a macro to paste data from one excel sheet ( which is designed as a form) into another excel sheet.
My issue is that how do I get the data to go to the next line. My current macro is pasting over the existing data wherea as I need it to go to...