Split up spreadsheet by sales rep

K

KrispyData

I have a spreadsheet that contains all the account information for every
sales rep in the nation. Is there a way to split up the spreadsheet by sales
rep? That way I can send each rep a spreadsheet tab with their own data.
 
R

Ron de Bruin

See the example on this page
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




KrispyData said:
I have a spreadsheet that contains all the account information for every
sales rep in the nation. Is there a way to split up the spreadsheet by sales
rep? That way I can send each rep a spreadsheet tab with their own data.

__________ Information from ESET Smart Security, version of virus signature database 3952 (20090320) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 3952 (20090320) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct with COUNTIF With An INDIRECT 1
IF Statement Help 6
How do I email individual tabs in a workbook? 1
'If' formula 5
vlookup? 5
Drop down need to validate information 5
Lookup to create a table of data in terms of selection 1
Auto Populate One Pages from spreadsheet 0

Top