Excel 2003 Copy paste with data already there Question

[hubba]

Hi All,
This is my issue, I have data in cells B3 to B11, they have something like Fine $350, Fine $40 and so on down the cell range

I need to transfer all the data in the cells in to one cell so it shows like this, Fine $350, Fine $40, Fine $550 and so on.

I try copy then paste in to the top cell (EG: copy data in cell B5, then select last bit of data in cell B1 so cursor is flashing, then want to paste, but Paste option on Right click or Ctrl V does not work, Data is shown on the clip board and can paste this way but just want to see if there is another way to do this. At this stage can not use macros but if someone has one let me know.

Thanks
Karl

 

[northwolves]

Did you mean the following:

Sub macro1()
Range("b1") = Join(WorksheetFunction.Transpose(Range("b3:b11")), ",")
End Sub

 

[hubba]

Yes for macro (will try it)

Thanks
karl