+ Reply to Thread
Results 1 to 11 of 11

VBA Looping for copy paste after running analysis

Hybrid View

  1. #1
    Registered User
    Join Date
    04-13-2014
    Location
    Vancouver, WA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: VBA Looping for copy paste after running analysis

    Thanks for pointing that out, Fotis1991. My bad, indeed.

    Everything highlighted will be repeated. However, the cells highlighted in blue will stay the same while the others will need to be filled row by row until the last date from the output worksheet range B8:B1500 has been copied, and the results pasted.

    Sub Runner() 'finansator
    Dim wo As Worksheet, wa As Worksheet
     'Change Date
    Set wo = Worksheets("Output"): Set wa = Worksheets("Analysis")
    wo.Range("B8").Copy: wa.Range("C10").PasteSpecial Paste:=xlPasteValues
     'Copy and Paste Outputs From Analysis Tab to Outputs Tab
    wa.Range("G6").Copy wo.Range("D8").PasteSpecial Paste:=xlPasteValues
    wa.Range("G7").Copy:  wo.Range("E8").PasteSpecial Paste:=xlPasteValues
    wa.Range("G17").Copy: wo.Range("F8").PasteSpecial Paste:=xlPasteValues
    wa.Range("H6").Copy:  wo.Range("G8").PasteSpecial Paste:=xlPasteValues
    wa.Range("H7").Copy:  wo.Range("H8").PasteSpecial Paste:=xlPasteValues
    wa.Range("H17").Copy: wo.Range("I8").PasteSpecial Paste:=xlPasteValues
     
     ' I need this is will be repeated until there are no more dates
    
     End Sub
    Last edited by finansator; 04-14-2014 at 10:01 AM. Reason: clarification

+ 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. [SOLVED] Help with Looping a copy and paste marco
    By Robert110 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-26-2013, 11:02 AM
  2. [SOLVED] VBA Looping Copy and Paste
    By harrison298 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 11:43 AM
  3. Looping Through Some Sheets to Sort Copy & Paste
    By luke1438 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2010, 12:57 PM
  4. Looping Copy/Paste Macro
    By yuuuh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2010, 11:56 PM
  5. Looping and copy/paste specific rows
    By Desi_bhai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2007, 12:50 PM

Tags for this Thread

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