I have a workbook that is a repository for information. Basically, you put the required data in the blocks, then click a submit button. The coding will then create a new sheet for this information with a unique name. To avoid duplicate entries, the code also verifies that a sheet with that unique name does not already exist. This sheet is used by multiple users across multiple computers on our work server. The issue I am running into is that not everyone's computer is as powerful as mine, and as the repository grows it is taking a long time/freezing up on the slower computers.
I know there are plenty of methods to verify that a sheet exists or not, but I need one that can run smoothly on weak machines when there are hundreds of sheets in the workbook to check against. Thanks in advance!
I know there are plenty of methods to verify that a sheet exists or not, but I need one that can run smoothly on weak machines when there are hundreds of sheets in the workbook to check against. Thanks in advance!