Can anyone help me?
I have a macro that copies and pastes one piece of data at a time
Sub PasteText()
ActiveSheet.PasteSpecial Format:="Text", Link:=False, _
DisplayAsIcon:=False
End Sub
But I wish to use a macro that will copy multiple pieces of data (can vary from 2 to 20 pieces) then paste on Microsoft office Excel starting from different locations down columb G with 8 rows separating each piece of data
Thanks.