Share via

Selecting non-contiguous rows and pasting the values elsewhere

Anonymous
2023-05-12T21:03:47+00:00

I have a workbook that is used by multiple users unfamiliar with excel for the most part. I am attempting to make it VERY simple to use without the users causing problems with the data or the workbook. Is there a way using VBA to select multiple rows (up to 26) that may or may not be contiguous by simply "clicking" on each row individually, then pasteing the Values Only elsewhere with no blank rows in the pasted list?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-12T23:32:55+00:00

    Hi there

    No need for a code,

    Try the following steps

    1. Selects the cells you want to copy (contiguous or not)
    2. Press CTRL + C to copy them
    3. Select the destination cell
    4. Press, Ctrl + Alt + V + V + ENTER to paste the cell range as values with no blank rows in the pasted range

    RESULT

    I hope this helps you and gives a solution to your problem

    Do let me know if you need more help

    Regards

    Jeovany

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-05-14T22:57:12+00:00

    1) Re, "... I would like for them to just be able to click on a row or rows without having to hold down the crtl key*."*

    I might be wrong... but I'm afraid that's not possible in Excel

    2) Re, "...Once that is done, I wanted place a "Button" on sheet that would allow them to put the information in another place in the workbook."

    The closest idea/ suggestion I have is:

    1. Create a Data Validation dropdown list for the Users to select the info/cell they want to copy/transfer to another sheet.
    2. Which will be similarly selected from another dropdown list
    3. Only then, with a button's help, run the macro and copy the "Yes" rows with the relevant info to the selected sheet.

    0 comments
  3. Anonymous
    2023-05-13T00:10:00+00:00

    I can do this easily. The folks I am trying to help will have difficulty and will either mess up or damage the workbook that they are being required to fill some numbers into.

    I would like for them to just be able to click on a row or rows without having to hold down the crtl key. Just pick multiple rows. Once that is done, I wanted place a "Button" on sheet that would allow them to put the information in another place in the workbook.

    0 comments