This code splits a worksheet into multiple sheets (based on sales person in column A). But when it does it, it deletes the sheets and then re-creates them. However this messes with my formulas I have linked to the split sheets and turns them into #REF! errors.
Can someone edit the code below to simply clear the cells and replace with the updated data? I will make sure blank sales person worksheets are set up in advance.
Please Login or Register to view this content.