The text my functions return doesn’t spill over to adjacent cells on the new worksheet.
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!
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! Read More