+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Selective Copy with skipping rows in between

  1. #1
    Registered User
    Join Date
    08-05-2006
    Posts
    63

    Selective Copy with skipping rows in between

    Fellow Forum Members,
    I would appreciate it a lot if someone can help me develop a macro that will let me selectively copy cells and allow me to control the quantity of rows I need skipped between each copied cell.

    Currently I press the CONTROL button and manually select 50 cells in "Column A" and manually skip 3 rows between each cell I select to copy. The result is 50 cells selected with three rows in between each selected cell.

    This is tedious work and I need a macro that would ask me three questions before I run it:

    Question One: What is the first cell you want to copy?

    My answer is : "A1"

    Question Two: Total number of cells you want to copy below Cell "A1"?

    My answer is : X (Could be 25, 30, 40 could be any number)

    Question Three: How many blank rows do you want to skip between each of the copied cells starting with cell "A1" ?

    My answer is : X (could be 3, 4, 5, 6, 7, could be any number)

    IS such a macro possible? I need to set this up because I am spending too much time doing this custom type of copying over and over again. If any one can help me out in developing such a Macro I would be very grateful.

    Thanks.
    Last edited by binar; 02-03-2009 at 01:18 AM.

+ 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