+ Reply to Thread
Results 1 to 6 of 6

Make 3 rows relative to 1 row on previous sheet, then REPEAT!

  1. #1
    Registered User
    Join Date
    06-08-2013
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2010
    Posts
    3

    Make 3 rows relative to 1 row on previous sheet, then REPEAT!

    Hey Guys,

    Basically, I have a long list of records and need to rearrange it so that in the new sheet, the data will span 3 rows. So, I created formulas to place the data from the first sheet where I want it to be on the second. So on the second sheet, the first 4 rows are relative to the first row in the first sheet. I would like the next four rows to be relative to the second row, and so on.

    However, simply copying the first 4 rows and pasting makes the next group relative to row 5, not row 2.

    Screen Shot 2013-06-08 at 12.47.30 AM.jpg

    I tried selecting the just the first column and filling down, but rather than starting with row 4, it starts with row 14.

    I there any way to get excel to continue the pattern in my groups of rows?

    Any help or ideas would be greatly appreciated.
    ~Bob

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,162

    Re: Make 3 rows relative to 1 row on previous sheet, then REPEAT!

    A jpg is of no use to us as users here will not re-create a file from a picture.

    So its better you attach a sample file -

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    06-08-2013
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Make 3 rows relative to 1 row on previous sheet, then REPEAT!

    Here is a sample file!


    AST.xlsx

    Thanks!

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,139

    Re: Make 3 rows relative to 1 row on previous sheet, then REPEAT!

    find the attachment
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Make 3 rows relative to 1 row on previous sheet, then REPEAT!

    Or with an macro (see the attached file).

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  6. #6
    Registered User
    Join Date
    06-08-2013
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2010
    Posts
    3

    Cool Re: Make 3 rows relative to 1 row on previous sheet, then REPEAT!

    Thanks guys! This is awesome!

    I'm going to go without the macro! :-)

    Take care,
    ~Bob

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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