Hello,
Is there a way to click a button which selects a row of data and copies it into another workbook, with the data not in one row? i.e scattered around the page?
thanks
Hello,
Is there a way to click a button which selects a row of data and copies it into another workbook, with the data not in one row? i.e scattered around the page?
thanks
Off the top, not testedOriginally Posted by boxcaru
[vba]
Sub CopyData()
Dim i As Long
Dim cell As Range
For Each cell In Selection
i = i + 1
cell.copy Worksheets("Sheet2").Range("A" & i)
Next cell
End Sub
[/vba]
Select all your cells to copy using Ctrl-Click, and then run the macro.