+ Reply to Thread
Results 1 to 4 of 4

Copy Specific Rows with Column that Varies

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    Philippines, Manila
    MS-Off Ver
    Excel 2010
    Posts
    127

    Copy Specific Rows with Column that Varies

    Hello Everyone,

    I have these specific rows (2,3,4,6,43,44,45,63) which I would like to copy and paste it on a designated sheet. But my problem is, the column varies depending on the YEARS.

    I do have codes for it, the one I got from the recording. I just do it for all of the rows (formula pasted here) until all of it copied on the summary sheet. However, when I finally finished it
    and I run it. I could see the movement form One Sheet to another and its not good.

    So I was hoping if someone could help me and improve my basic codes. A code that I could use for my better understanding of MACRO.

    Please Login or Register  to view this content.
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy Specific Rows with Column that Varies

    can you advise what actually changes? year on year?

    you could probably achieve this without macro to be honest
    see attached two ways of doing it without macro
    Attached Files Attached Files
    Last edited by humdingaling; 07-15-2014 at 12:05 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    04-09-2013
    Location
    Philippines, Manila
    MS-Off Ver
    Excel 2010
    Posts
    127

    Re: Copy Specific Rows with Column that Varies

    The column changes depending the number of years.. Lets say I have a data that contains 5 years... So I will have 5 columns..

    But your right, I could use your formula instead

    Thank you by the way... Another way of doing it ^_^
    Last edited by Jarvin24; 07-15-2014 at 01:48 AM.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy Specific Rows with Column that Varies

    here is code to do what you want via macro

    Please Login or Register  to view this content.
    only B8 need paste special values...the rest a straight copy will suffice
    Attached Files Attached Files
    Last edited by humdingaling; 07-15-2014 at 02:10 AM. Reason: attached file

+ 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. Replies: 0
    Last Post: 12-02-2013, 02:50 PM
  2. [SOLVED] copy column headers into rows if it meets a specific criteria
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-30-2013, 06:05 AM
  3. Copy rows containing in column A specific word
    By Odeen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2013, 10:24 AM
  4. Copy rows with values in specific column to first empty row in specified sheet
    By scaffdog845 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2013, 08:29 PM
  5. Copy rows with a specific value in column A
    By Gert-Jan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-23-2006, 12:20 PM

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