I need to fill a single row on one sheet with table data in second sheet.
I've attached a sample workbook which illustrates what I want to accomplish.
Thank You!
I need to fill a single row on one sheet with table data in second sheet.
I've attached a sample workbook which illustrates what I want to accomplish.
Thank You!
=INDEX(Sheet1!$15:$15,(ROW($A1)-1)*7+COLUMN(A$1)) pull to the right and down
Hmm, there shouldn't be any additional rows in Sheet1. We need to fill row 15, from column A until (about) column DX.
So columns H65:M65 in Sheet 1 should contain the data in cells A3:F3 in sheet2. And repeat to the right (leaving an empty column between these "sets" as you see in Sheet1.
Does that make sense?
Thanks!
Try this in Sheet1 A15 and filled right as far as needed.
=INDEX(Table1,(COLUMN()-1)/7+1,MOD(COLUMN(),7))
Try this formula
Formula:Please Login or Register to view this content.
Thanks everyone. I couldn't get either script to work so for now I just plugged in the numbers.
The solutions at Posts 4 and 5 both seem to be OK??!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here's the solution from post 4
If the error 'between' each section is a problem, just add IFERROR
=IFERROR(INDEX(Table1,(COLUMN()-1)/7+1,MOD(COLUMN(),7)),"")
Thanks. Yes I think you're right. The spacing column must be what screwed it up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks