Extracting excel worksheet data to separate files

[email4matt]

We have a large spreadsheet that gets created monthly, and contains
staff goals. Rather than email each person the entire document, we'd
like to only send them their own information. So, I'd need to have
the top 4 rows of the document (header information), and the row under
that specific to each user.

Does anyone know of a way to export this information? Manually
cutting/pasting each person's info is not feasible due to the number
of people we have.

Thanks for your help!

 

[Ron de Bruin]

Hi

One way is to split the file in different sheets or workbooks
http://www.rondebruin.nl/copy5.htm

Where are the mail addresses of all persons (in the data? )

Or is there only one row with data for each person ?

 

[email4matt]

Hi

One way is to split the file in different sheets or workbookshttp://www.rondebruin.nl/copy5.htm

Where are the mail addresses of all persons (in the data? )

Or is there only one row with data for each person ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm







- Show quoted text -

Thanks for your reply. Right now, the email addresses are not in the
spreadsheets. There is only one row per person - and the row contains
all of their goal information.

 

[Ron de Bruin]

Add the mail addresses and try this macro

This macro is build for one header row
So test it first with one row

http://www.rondebruin.nl/mail/folder3/row.htm

 

[Ron de Bruin]

Download the example workbook in the Body section to test it
http://www.rondebruin.nl/sendmail.htm