Split worksheet into multiple worksheets

**ashtanga** · 08-12-2009, 01:05 PM

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.

Thanks!

Please Login or Register  to view this content.

**JBeaucaire** · 08-12-2009, 03:00 PM

Maybe like this:

Please Login or Register  to view this content.

**ashtanga** · 08-12-2009, 03:37 PM

Thanks, it nearly works. It puts my first sales person into the Unique worksheet and leaves that sales person's worksheet empty?

**ashtanga** · 08-12-2009, 03:40 PM

And when I deleted a sales person worksheet, rerun the macro, the worksheet wasn't replaced.

**ashtanga** · 08-12-2009, 03:45 PM

oops forget those comments I was running the macro from the worksheet

**JBeaucaire** · 08-12-2009, 04:43 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)