Results 1 to 3 of 3

Copy & paste ranges separated by blanks

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2008
    Location
    Delhi
    Posts
    2

    Copy & paste ranges separated by blanks

    Hi,

    I require the VBA code for the following logic.
    I have some data in Column A of Sheet1 with blank cells in between. Now find the range of data till we get blank, copy and paste that data in Column A of Sheet2, then leave all the blanks again find the range of data till we get another blank, copy and paste that data in Column B of Sheet2, repeat the same till we reach end of the Column A.
    I attached the Gif file for better understanding.

    Looking forward of the VBA script. If you send the code immediately that would be great help

    Vijay
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy / Paste Pivot Table to PPT
    By skizz135 in forum Excel General
    Replies: 1
    Last Post: 07-08-2008, 02:36 PM
  2. Copy and Paste Question
    By panproblems in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2008, 07:42 PM
  3. speed - variables vs copy paste
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2008, 03:34 PM
  4. Copy and paste to next empty cell
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2007, 11:27 AM
  5. Replies: 1
    Last Post: 07-01-2007, 06:21 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