+ Reply to Thread
Results 1 to 2 of 2

VBA loops: conditional copy to another worksheet

  1. #1
    Registered User
    Join Date
    08-02-2007
    Posts
    7

    VBA loops: conditional copy to another worksheet

    Hi guys,

    I need a hand to solve this one.
    I have two columns, the first contains the data to be copied, the second contains the frequency it will be copied with.

    I need to copy this data to another worksheet so it will contain one row but the first cell will be copied three times, the second only once, the third five times and so on.

    Thanks a lot. Cheers.

    R0008DJ443 3
    R0105DJ426 1
    R0107DJ427 5
    R0205DJ866 16
    R0208DJ946 3
    R0308DJ946 1
    R0406DJ437 17

  2. #2
    Registered User
    Join Date
    08-02-2007
    Posts
    7
    it should look like

    varA:1 to end of row A
    varB:1 to read cell (B,varA)

    copy cell (A,varA)
    paste cell (A,varA)

    next varB
    next varA

    sorry about my programming skills

+ 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. Copy and paste unique values to another worksheet
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2009, 11:44 AM
  2. copy cell data from worksheet to worksheet
    By lizerdboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2007, 02:54 PM
  3. [SOLVED] Copy and Paste from many workbooks into one worksheet
    By Paul Morgan in forum Excel General
    Replies: 4
    Last Post: 02-18-2007, 03:42 PM
  4. Replies: 6
    Last Post: 11-18-2006, 08:42 PM
  5. Worksheet copy problem
    By Willow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2006, 09:56 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