Steven Morgan Posted October 24, 2019 Share Posted October 24, 2019 Is there a way in my Criteria Formula to choose the array of rows that get returned? For instance if I have 100 rows of data and I want to make 4x different worksheets. WS1) 1-25 WS2) 26-50 WS3)51-75 WS4) 76-100 It would be a nice way to breakup long worksheets compared to placing them in viewports and cropping them. Thanks! Quote Link to comment
Pat Stanford Posted October 24, 2019 Share Posted October 24, 2019 The only way to do this would be to create four worksheets each with a slightly different Criteria. And there is no criteria to specify the number of lines, so you would need to use something in a record attached to the objects to create the separation. 😞 Quote Link to comment
Steven Morgan Posted October 24, 2019 Author Share Posted October 24, 2019 Bummer. Thanks Pat! 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.