+ Reply to Thread
Results 1 to 5 of 5

Variable range copy paste

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    Devon
    MS-Off Ver
    Excel 2010
    Posts
    3

    Variable range copy paste

    Hi all. My first post so thanks in advance.
    I have a excel doc that contains a list of names, say 10 columns. I need to move these into a new sheet under different headings.
    The column data always starts at row 10 due to headers and other data that is required.
    The rows sizes are always different depending on how many people attend an event.
    I will be running each row independently so if I could get an example using the following I may well be able to do the rest.
    Lets get their names;
    Sheet2 Column B At Row 10
    Move to Sheet1 Column L Row 4
    I am quite happy using VBA
    Thanks
    Scott

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Lightbulb Re: Variable range copy paste

    Hi
    How about something like the attached example?

    Hope this helps
    Last edited by DBY; 04-24-2012 at 08:15 AM. Reason: Removed attachment

  3. #3
    Registered User
    Join Date
    04-24-2012
    Location
    Devon
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Variable range copy paste

    yep 10/10
    Works great. Many thanks for helping me out
    Cheers Scott

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Red face Re: Variable range copy paste

    Hello again
    Just realized that you will need to remove the old list in Sheet1 before copying the new one, else you may get remnants of the old list if the sizes vary, so I've removed my original attachment and replaced it with this amended one.

    Sorry for any confusion.

    DBY
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-24-2012
    Location
    Devon
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Variable range copy paste

    Thanks for the update. Sorry took so long to get back.
    Appreciate you following that up. All the best Scott

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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