+ Reply to Thread
Results 1 to 2 of 2

Excel 2013: This command cannot be used on multiple selectiong (copy/Paste Troubles)

  1. #1
    Registered User
    Join Date
    06-30-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    7

    Excel 2013: This command cannot be used on multiple selectiong (copy/Paste Troubles)

    Hello all,

    I am an excel noob who often tends to struggle with it. My latest issue is with copying and pasting multiple groups of text from the same column. The excel file I am referring to is posted here as an attachment and what I am trying to od is c/p the groups of text under the nonrecyclable (column G) for each of the four weeks at the same time. I am holding on to the ctrl key while selecting all these groups of text but when I click copy, I get the error message. I understand I can c/p each group of text one by one but I want to learn a way to c/p all the groups of text at the same time since I need to c/p from many of these types of excel sheets.

    If anyone can give me a solution to my problem it would be greatly appreciated! Also I am not too knowledgeable about all of the vba and macro stuff so go easy on me!
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,964

    Re: Excel 2013: This command cannot be used on multiple selectiong (copy/Paste Troubles)

    You could try selecting the rows that you want to copy with an auto-filter. You may need to remove the long merged cell at the top of the sheet in order to do this.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help converting Excel 2013 command into Excel 2010
    By xMaximus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2015, 06:24 PM
  2. Excel 2013 - Macro to copy + cut paste in a table
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2014, 09:20 AM
  3. [SOLVED] Paste formula: Excel 2013
    By jlb333333 in forum Excel General
    Replies: 11
    Last Post: 03-31-2014, 02:18 AM
  4. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  5. Command Button Troubles
    By bibleguy125 in forum Excel General
    Replies: 5
    Last Post: 01-14-2012, 04:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1