The text my functions return doesn't spill over to adjacent cells on the new worksheet.

Copper Contributor

Hello everyone! I'm a bit new to excel, but despite that i've tried my hands at what i consider a "difficult" challange. 

 

I'd like to have two sheets, one that contains all the information, and a second one that acts as a "printable version" where i've only placed parts of the information that may be relevant for said project. 

 

To do this, I've added a checkbox system on my data page, where i can simply check the box and said row gets transffered over to the other page in a dynamic way.

(So i can press box 1 6 and 9, and they'll be placed right under eachother in order. Should i then add box 2, that will squeeze it's way inbetween 1 and 6 in the previous data set... Hard to explain but you'll understand if you look at the sheet. 

 

My issue is that the text and information that gets placed on my "printing page", don't spill over into the adjacent cells, as it normally would've if i simply wrote the text out. I suspect this has to do with the fact that my function seems to be returning the entire row as a large "block" rather than several columns. But i've got no idea on how to fix it. 

 

I should also mention that i'm not the author of the function, but i've tweaked it slightly to fit my needs. 

 

I'd appreciate any help on the subject. Thanks! 

3 Replies
=IFERROR(INDEX(Databas!A2:H40,SMALL(IF(Databas!I2:I40=TRUE,ROW(Databas!I2:I40)-ROW(Databas!I2)+1),ROWS(Databas!I2:I2)),0),"")
The code above is what i'm using to pick up the information from the other sheet.

For every new row i add an additional row in the last part of the function. so instead of I2:I2 it's now I2:I3, then I2:I4 and thus forth. See below for an example of how the second row would've looked

=IFERROR(INDEX(Databas!A2:H40,SMALL(IF(Databas!I2:I40=TRUE,ROW(Databas!I2:I40)-ROW(Databas!I2)+1),ROWS(Databas!I2:I3)),0),"")

tobiasmohlin_0-1727854507164.png

Here's how it looks. 

 

tobiasmohlin_1-1727854536478.png

And this is how i'd like it to look. 

As it turns out, the filter function was way easier to achieving what i was after. That being said, it still doesn't make the text fluent over the various rows... it's still wonky and not good looking... please help!