Excel 2007
Concatenate when pasting.
Instead of replacing the destination cell when pasting copied data I want Excel to concatenate the copied cell with the destination cell and add the “/”-character in between.
Example:

A1:1
A2:2
A3:3

B1:4
B2:5
B3:6

If A1:A3 is copied and B1 is selected and the macro is run. I want the result to look like this:

B1:1/4
B2:2/5
B3:3/6

If B2 is blank the result in B2 should be “2”, not “/2”
The macro should be able to handle large ranges not just one column.

Thanks for helping me out :)