Special Paste

[kipper]

Hi,

If I have a list a names in the same column, is there a way to paste them one after one, in the order in which they appear? (not together but separately)
I mean each CTRL + V will paste for me the next name in the column, and I won't need to go to every name in order to copy and paste it separately. For example, if I have a column that lists the numbers from 1 to 10, so I want to copy it and paste it so each CTRL + V will give me the numbers one after another (next in line), and not all at once.

Thanks in advance!

 

[Robert Mika]

Hi kipper,
This probably is not possible unles you use some kind of sophisticated macro.
Alternatively you can use the clipboard and the paste the values as you want.

 

[wigi]

Why not use another shortcut, linked to a macro that does the copy action in the activecell/selection. Memory or a cell could keep track of where in the column you are (which cells were pasted already).

Alternatively, use an event in VBA like double click or right click.

 

[kipper]

Can you please give me a kind of macro like this? Thanks !

 

[zuslan]

You can try the following code (according to suggestion from wigi):

Sub copy_one_by_one()

Dim x As Variant

x = ActiveCell.Address

Range("A1").Select
If Not IsEmpty(Range(x).Offset(-1, 0)) Then
    Do Until ActiveCell = Range(x).Offset(-1, 0)
        ActiveCell.Offset(1, 0).Select
    Loop
    ActiveCell.Offset(1, 0).Select
End If

Range(x) = ActiveCell
Range(x).Offset(1, 0).Select

End Sub

Assumptions: values from 1 to 10 are stored in A1:A10.

 

[wigi]

Or simpler:

Sub copy_one_by_one()
    With [Temp!A1]
        .Value = .Value + 1
        ActiveCell.Value = WorksheetFunction.Index([Names!A1:A20], .Value, 1)
    End With
End Sub

Cell A1 on sheet Temp tracks which cell from the list we will be pasting / how many were done. Sheet Names, cells A1:A20 is the list of names that will be pasted one after the other (1 name per execution of this procedure).

Change the code and/or your sheets to accomodate.

Please do not PM me, I do everything I can to answer as many people and topics as possible. Future PMs will not be answered. Thank you for consideration.

 

[kipper]

Thanks you both very much, I'll try thats two.
If I will had problems I'll get back...

 

[kipper]

Okay, I tried that two macros, and none of them worked for me as I expected them to work: I received messages that notice of bugs, and every time I tried to paste I got a popup with message that asking me if I want to make this operation or something like that, and it did not work smoothly.
Important - I want to emphasize: the idea is to copy from the Excel to another software, NOT or copy it into Excel or something like that.
What to do now?

PS : And of course, thanks for the time you invested in writing the formulas

 

[wigi]

Important - I want to emphasize: the idea is to copy from the Excel to another software, NOT or copy it into Excel or something like that.

Thank you for not mentioning this in your post so that I wasted my time on this one. If I had known this, I would not have suggested my solution since that is not going to work in 'another software'.