Lisar Posted March 22 Share Posted March 22 I often find I have limited space for plant lists on my sheets. Is there an easy way to divide a plant list into portions alphabetically? For example, plants starting with A-H as one report, then another report showing plants I-Z? Thanks in advance. Quote Link to comment
Ben Miura Posted March 22 Share Posted March 22 Curious as well. Currently I use view ports or "White rectangles" to separate a plant schedule. very laborious. 1 Quote Link to comment
Popular Post Jeff Prince Posted March 22 Popular Post Share Posted March 22 You can use duplicate worksheets with different criteria to do this. See the image below. This will report plants with names that start with "m" or earlier in the alphabet. For the other worksheet, you would change the criteria to greater than or equal to "n" to get the remaining plants. This results in two worksheet you then have to manage, but it will do what you are asking. Best if you place them on the sheet layer too. 5 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.