+ Reply to Thread
Results 1 to 3 of 3

Copy/paste values from multiple selection into new workbook

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Copy/paste values from multiple selection into new workbook

    Hi

    I've spent a few hours this morning trawling through numerous forums and posts trying to get my head around a multiple selection copy/paste issue I seem to be having.

    I keep a master workbook in which I need to collate data sent to me from a number of different regions across the globe. I send out a copy of this workbook which the regions fill in then submit to me.

    My problem is basically this - I wanted to run a macro that copies all the purple cells in each of their workbooks (for which I have named a range, "purplecells"), then lets me paste this data into my workbook.

    With the following macro I am able to copy all of those cells (I'm still a macro beginner so plz be nice! ):

    Sub SelectPurpleCellsAmericas()
    '
    ' SelectPurpleCellsAmericas Macro
    '

    '
    Sheets("Americas").Select
    Range("purplecells").Select

    End Sub


    But when I select the same range of cells in my workbook then try to paste, I get the ever frustrating "That command cannot be used on multiple selections" error.

    Attached is a basic version of the workbook I deal with. Admittedly the data collection process could do with a complete overhaul IMO.

    Appreciate any help you can provide.

    Cheers

    Gigi
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,575

    Re: Copy/paste values from multiple selection into new workbook

    you should only be selecting a single cell.

    the following code works:-

    I used it to copy three areas not linked to each other. they ended up pasted together.
    So if you want the seperate areas to stay seperate then you need to move them individually.

    Please Login or Register  to view this content.

    The range I selected was
    Please Login or Register  to view this content.
    So each seperate group is the same number of cells
    Last edited by mehmetcik; 03-31-2014 at 10:25 AM.

  3. #3
    Registered User
    Join Date
    01-03-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Copy/paste values from multiple selection into new workbook

    Sorry I stated new workbook in the subject line but I meant into a different workbook - mine will essentially look the same as the one that I uploaded here. There will be data in all the other columns between the purple ones as well, which I can't paste over.

    Would I essentially have to name each block of purple cells individually and use a macro to run the copy/paste function?

+ 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. Using current month selection to copy/paste formulas and values
    By gigi85 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2014, 07:51 AM
  2. [SOLVED] please help on addins for copy selection, paste to a new workbook and edit the title
    By ruliansyah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2013, 01:14 AM
  3. copy and paste multiple selection
    By chopstxnrice in forum Excel General
    Replies: 11
    Last Post: 04-09-2013, 08:57 AM
  4. Macro to copy a selection, paste it in a new workbook then loop
    By AK262007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2010, 06:35 AM
  5. [SOLVED] copy and paste multiple selection
    By Gareth in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-13-2010, 04:28 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