+ Reply to Thread
Results 1 to 3 of 3

Skipping rows, copying, subtracting...

  1. #1
    Registered User
    Join Date
    08-15-2008
    Location
    NC
    Posts
    9

    Skipping rows, copying, subtracting...

    Say I have Rows 1 through x and Columns A through AQ. Row 1 is the name of the columns, so ignore it. I would like to do this:
    For Columns A, B, D, E, F, G, H, I: Take Row 2 and copy it to Row 4
    For Column C: On row 4, put "LastHalf"
    For Columns J through AP: each column equals that column on Row 2 minus that column on Row 3 (for example, 4,J = 2,J - 3,J).

    Now where this become difficult (for me) is that I want this to repeat for every third row. So Row 4 needs to do this based on the two rows above it, then Row 7 needs to do this for the two rows above it, then Row 10 needs to... you get the drift. Every third row (all of them will be blank) needs to automatically fill in based on the two rows preceding it.

    I know this is a lot to ask, but I'm desperate...

  2. #2
    Registered User
    Join Date
    08-15-2008
    Location
    Mass
    MS-Off Ver
    2016, 64- Bit
    Posts
    36

    copy paste

    Once you setup the intial 3 rows according to your specifications (minus the headings), all you have to do is to copy range A2:AP4 and paste it at the next available "A" row where there is no 0 and repeat . Because the cells references aren't absolute you should have no problem. See attached.

  3. #3
    Registered User
    Join Date
    08-15-2008
    Location
    NC
    Posts
    9
    Don't see any attachments...

+ 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. Multisheet formula autofill while skipping rows
    By SimTurner in forum Excel General
    Replies: 6
    Last Post: 09-29-2012, 08:03 PM
  2. macro inserting and copying rows
    By Guy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2008, 01:52 PM
  3. copying rows from 1 sheet to another
    By phong919 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2008, 04:19 PM
  4. Sealecting rows by value and copying to new sheet
    By cleaco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2008, 05:50 AM
  5. copying top 15 rows
    By dj_siek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2007, 06:48 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