Results 1 to 12 of 12

Loop copy and paste

Threaded View

ScabbyDog Loop copy and paste 03-03-2013, 01:34 PM
Norie Re: Loop copy and paste 03-03-2013, 01:56 PM
ScabbyDog Re: Loop copy and paste 03-03-2013, 01:59 PM
Mumps1 Re: Loop copy and paste 03-03-2013, 02:07 PM
ScabbyDog Re: Loop copy and paste 03-03-2013, 02:19 PM
ScabbyDog Re: Loop copy and paste 03-03-2013, 02:32 PM
AB33 Re: Loop copy and paste 03-03-2013, 02:45 PM
ScabbyDog Re: Loop copy and paste 03-03-2013, 03:05 PM
ScabbyDog Re: Loop copy and paste 03-03-2013, 02:52 PM
ScabbyDog Re: Loop copy and paste 03-03-2013, 02:56 PM
AB33 Re: Loop copy and paste 03-03-2013, 03:00 PM
AB33 Re: Loop copy and paste 03-03-2013, 03:11 PM
  1. 03-03-2013, 01:34 PM #1
    ScabbyDog is offline
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Loop copy and paste

    I need a macro that copies range O1:O21 on sheet1 and then goes to sheet2 and checks to see if B2 is blank. If it is blank paste values into b2. If it is not then shift cells right and then paste values into b2. After it pastes the values, repeat the above 500 times. Possible?
    Last edited by ScabbyDog; 03-03-2013 at 01:38 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1