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 ?
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
wrote in message ups.com...
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!