Breaking One workbook into many Tabs
 

Start here
http://www.rondebruin.nl/copy5.htm

--

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


"Darin Kramer" wrote in message ...

Hi There

I have a tab called "Master" with information on lines 2 to 130, and
Columns A to S. Column F has information that is repeated on several
lines (persons name) I want to break the single tab "master" into a
number of sub tabs, each tab containing the information relevant only to
the individual.

Thus for example

Rows 1, 4, 7 and 9 within Column F state John. I want to extract all
relevant info for John (ie contents of Rows 1,4 and 7) into a new tab
called John (such that I can send JOhn his tab)

Is there a way to break up the Master tab into sub tabs?

Regards

D


*** Sent via Developersdex http://www.developersdex.com ***

Breaking One workbook into many Tabs
 

Ron,

Thank you very much - works like a charm!

*** Sent via Developersdex http://www.developersdex.com ***

Breaking One workbook into many Tabs
 

For creating the mails without creating seperate tabs see
http://www.rondebruin.nl/mail/folder1/row2.htm

If you use Outlook

http://www.rondebruin.nl/mail/folder2/row2.htm

Or in the Body
http://www.rondebruin.nl/mail/folder3/row2.htm


--

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


"Darin Kramer" wrote in message ...


Ron,

Thank you very much - works like a charm!

*** Sent via Developersdex http://www.developersdex.com ***