Sep 22 2022 06:23 AM
Hi I'm currently trying to create a document which allows people in the office to create a finished H&S document with existing text inputted using tickboxes. I've installed the tickboxes and the relevant info associated with them without any issues however the only way I could think of populating the final document was using the filter function
=FILTER('Workings page'!E13:E18,'Workings page'!D13:D18=TRUE,0)
This works fine on the simple lists where the data all fits on one line, however some of the data I wish to input is pretty much a paragraph of text and therefore it would spread over a number of lines.
When I tried merging the cells to fit the data within one cell it didn't work due to the spill error.
I'm not an expert in Excel so I was wondering whether there would be a method to insert the relevant text without a one line limit?
For example I was wondering whether a macro could be used to insert some rows if the tick box was checked? Or whether there is a different function that would lend itself to the task that wouldn't raise the spill error?
Sep 22 2022 06:26 AM
Sep 22 2022 07:05 AM
Solution@whall316 I don't know if I understand the problem. Are you looking for automatic word wrapping? Here is the button on the Home Tab:
it is the button with the ab and the c below (i.e. wrapped to next line)
if you have spill error because more than 1 item is checked then add a Concatenate or TextJoin function around the FILTER:
=TEXTJOIN(" ",TRUE,FILTER('Workings page'!E13:E18,'Workings page'!D13:D18=TRUE,0))
Sep 22 2022 07:59 AM
@Jan Karel Pieterse the only issue with this is that the finished document is already pretty much complete with all the column widths etc already set.
Sep 22 2022 08:02 AM
Sep 22 2022 07:05 AM
Solution@whall316 I don't know if I understand the problem. Are you looking for automatic word wrapping? Here is the button on the Home Tab:
it is the button with the ab and the c below (i.e. wrapped to next line)
if you have spill error because more than 1 item is checked then add a Concatenate or TextJoin function around the FILTER:
=TEXTJOIN(" ",TRUE,FILTER('Workings page'!E13:E18,'Workings page'!D13:D18=TRUE,0))