Excel: Can I make something similar to an autoflow text box?
I'm trying to make a attendance sheet for my church. Basically, it has the names of all the members of the congregation on it, and the usher marks who attends the service.
People are constantly joining our congregation and it is annoying have to alter the attendance sheet each time someone joins the church.
Currently the page is A4, and split in half vertically so the names go down one side, then start again at the top of the next half. What I am wondering is whether it is possible (as I am quite hopeless with Excel formula) to make the text automatically flow from the bottom of the first half to the top of the second half. This would be great so that when I enter a new name they all move down, and flow onto the next half. Is this possible, or am I better using something like Publisher? I currently use Publisher, but it's a bit tacky, and I'd rather use Excel for the ease of creating borders and boxes.
<img src=\"http://img.photobucket.com/albums/v208/knowledgelifeguard/homer21.gif\" alt=\"Image hosted by Photobucket.com\" width=\"125\" height=\"104.8\"> <font size=\"1\"><i>\"I like these real Saturdays, not like that fake one that almost got me fired.\"</font></i>