Need help with linking rows from sheets

**velocitygraphix** · 11-20-2013, 12:05 PM

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!

**Melvinrobb** · 11-20-2013, 01:35 PM

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.

**velocitygraphix** · 11-20-2013, 05:36 PM

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

**arlu1201** · 11-21-2013, 02:14 AM

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.

Need help with linking rows from sheets

LinkBack

Thread Tools

Rate This Thread

Display

Need help with linking rows from sheets

Re: Need help with linking rows from sheets

Re: Need help with linking rows from sheets

Re: Need help with linking rows from sheets

Thread Information

Users Browsing this Thread

Similar Threads

linking between sheets of same .xls

linking rows in two sheets, then sorting data in one, but not the other?

Linking Sheets

Linking to Sheets

Need help with linking sheets.

Bookmarks

Bookmarks

Posting Permissions