+ Reply to Thread
Results 1 to 2 of 2

Copy/paste special to another worksheet and in descending rows

  1. #1
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 2016
    Posts
    240

    Copy/paste special to another worksheet and in descending rows

    Hi all,

    I have two worksheets in a workbook, one called Calculations and one called Results. Calculations has a bunch of equations for running some data analysis that iterates through data sets using VBA code and results from each iteration are always output in cells A1:Z1. Results from each iteration need to be stored in the worksheet called Results.

    Basically I need some way of copying cells A1:Z1 from Calculations worksheet to Results but each paste operation has to be below the last, e.g.

    iteration 1: copy/pastespecial values only A1:Z1 from Calculations to A1:Z1 in Results
    iteration 2: copy/pastespecial values only A1:Z1 from Calculations to A2:Z2 in Results
    iteration 3: copy/pastespecial values only A1:Z1 from Calculations to A3:Z3 in Results

    Etc etc. This process continues for some amount of iterations that is user-defined (I have this bit sorted using a variable).

    I imagine there's some combination of pastespecial and xlup commands that can do this but I've tried to write the code without success. Can anyone offer any help?

    Thanks in advance.
    -Rob
    Last edited by TheRobsterUK; 08-14-2012 at 03:57 AM.

  2. #2
    Registered User
    Join Date
    08-13-2012
    Location
    Czech Republic
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    7

    Re: Copy/paste special to another worksheet and in descending rows

    make some variable, i.e.

    Please Login or Register  to view this content.
    and at the end of each iteration add one to this:

    Please Login or Register  to view this content.
    when pasting values to the result sheet, use offset:
    Please Login or Register  to view this content.
    or if you use copy and paste:
    Please Login or Register  to view this content.
    All your base are belong to us

+ 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