Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting excel worksheet data to separate files
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting excel worksheet data to separate files
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting excel worksheet data to separate files
Download the example workbook in the Body section to test it
http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I match data from two separate files in excel | Excel Discussion (Misc queries) | |||
Collating a set of separate excel files into a single worksheet or | Excel Discussion (Misc queries) | |||
Extracting data from multiple excel files. | Excel Discussion (Misc queries) | |||
How do I separate a worksheet into many files? | Excel Discussion (Misc queries) | |||
Open Excel files in separate sessions, not just separate windows? | Excel Discussion (Misc queries) |