View Single Post
  #1   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

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!