Create Automatic tabs by sales rep

Cynthia - Oct 2, 2015 at 07:37 PM
 Blocked Profile - Oct 2, 2015 at 08:30 PM
I have this information on one single tab (50 sales reps)
Colum A - Sales Reps
Colum B Revenue sold

I need to create a single worksheet for each of the reps including their information. so my file woul dhave 50 tabs. each tab with a single rep - any way to do that easily?

1 response

Blocked Profile
Oct 2, 2015 at 08:30 PM
Ok, anything is possible.

What is not possible is us making a turn key solution. Try this: build a macro and add a tab. Then after you have the tab creation code, build the code (record the macro) of what ever you need your spreadsheet to do, and combine them.

IF you need help after that, post where you are stuck, and we can build a loop and a variable count......

We can help when you are stuck...we cannot help if you want something done for you.