View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] email4matt@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Extracting excel worksheet data to separate files

On Jul 23, 2:07 pm, "Ron de Bruin" wrote:
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



wrote in oglegroups.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!- Hide quoted text -


- 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.