stayathomedad Posted January 30, 2022 Share Posted January 30, 2022 So I built a worksheet and then made multiple copies of that worksheet. Looking back, I wish I would have added more criteria than I did. Is there a way to edit multiple worksheets criteria as a group? Similar to the way multiple class attribute settings can be edited by simply selecting multiple classes and the "edit". I really don't want to edit all 30 of them individually. Quote Link to comment
Pat Stanford Posted January 31, 2022 Share Posted January 31, 2022 If the criteria for all 30 is the same, then you can edit one of them, select the criteria in the Formula Bar and copy it. Then go to each of the other 29, right click on the database header row and choose Edit Database Formula, select all and then paste the edited version. Should be pretty easy after the first one. 1 Quote Link to comment
stayathomedad Posted February 5, 2022 Author Share Posted February 5, 2022 Thanks for the tip! It will save some of the clicking for sure. 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.