Forum Discussion
Create a Formula to pull Data from 1 row, 3 columns on Sheet2 into multiple Rows and columns Sheet1?
I'm making badges for a club and each badge on Sheet1 is 5 columns by 7 rows, with one row and column in between each badge. When I try to make the formula autofill, It grabs every 8th or 9th name on...
As long as there is consistency in the row heights and row counts per badge, this can be done. See the attached workbook.
As I note on the _Info worksheet, the key concept is to use the ROW() function in each formula to let it figure out which row in Sheet2 should supply the data for that cell.
Blank rows on Sheet2 cause badges with zeroes for cell content. Those could be suppressed, but why bother? The formulas would be even more complex. And I would expect blank rows normally to appear only at the end of the Sheet2 list.