Re-populating cells

[boxcaru]

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

[Bob Phillips]

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 tested

[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.