+ Reply to Thread
Results 1 to 4 of 4

Need help with linking rows from sheets

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    TN, United States
    MS-Off Ver
    Excel 2007
    Posts
    40

    Need help with linking rows from sheets

    Hello, I was wondering if anyone would be able to figure this out. I have several sheets that I need to take the entire rows from and put into another sheet. The sheet that they are going to will be repeated every nth row. I need the first row from each sheet placed on another sheet, then the next and so on. After so many rows, it will repeat. So what it will look like is this if it makes sense

    Row1 sheet1
    Row1 sheet2
    Row1 sheet3
    Row1 sheet4
    Row1 sheet5

    Row2 sheet1
    Row2 sheet2
    Row2 sheet3
    Row2 sheet4
    Row2 sheet5

    etc....

    I thought if I did it manually then dragged the rows down, excel would recognize the pattern I am trying to do and repeat it, but no luck. Each block would be 7 rows, and I need to do Hundreds of blocks. So any manual process would take forever and a day..if you have any suggestions please help! Thank you!

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Need help with linking rows from sheets

    I would use the indirect function.
    Highlight the grey and blue cells, and drag down to add more rows.
    Change the green cells to match the actual names of your sheets.
    Attached Files Attached Files
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    04-23-2013
    Location
    TN, United States
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Need help with linking rows from sheets

    After some modify to fit my sheets, it works like a charm! I appreciate your help greatly~

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

    Re: Need help with linking rows from sheets

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    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]

+ 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. linking between sheets of same .xls
    By mjohn99 in forum Excel General
    Replies: 3
    Last Post: 10-19-2011, 09:39 AM
  2. Replies: 3
    Last Post: 11-27-2009, 05:52 PM
  3. Linking Sheets
    By rickschepp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2007, 04:15 PM
  4. Linking to Sheets
    By racer25 in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 09:00 AM
  5. [SOLVED] Need help with linking sheets.
    By ww in forum Excel General
    Replies: 4
    Last Post: 03-18-2005, 01:06 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