Write a macro to split out depts into individual files

Powersmj · May 2nd, 2002, 01:25 PM

Every month I get an Excel spreadsheet that lists about 30 departments. Each department has several rows of data (each line is labeled with the department number). I need to break the departments out into individual files and email each file to the appropriate department manager. I tried to record a macro to do this but didn't have any success. The tricky part is that the number of rows for each department changes every month. How can I write a macro that will do this?

Thanks!

Tom Schreiner · May 2nd, 2002, 02:01 PM

Hi
This would be somewhat involved in giving an explanation...
Best bet:
Mail me an example of your monthly book and an example of one individual file which would be created.
The individual files could be automatically emailed as well.
You would need to update a list of email addresses for the departments if they change.

TsTom@Hotmail.com
Tom

Another question:
Are the individual files Excel worksheets?
Would you be emailing the sheets as attachments or simply the text?

[ This Message was edited by: TsTom on 2002-05-02 13:03 ]

waderw · May 2nd, 2002, 02:18 PM

TsTom you are the man! You are really helpful. You just helped me with my macro b/c I emailed you the wb.

Thanks man!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 01:25 PM	#1
Powersmj New Member Join Date: May 2002 Posts: 13	Every month I get an Excel spreadsheet that lists about 30 departments. Each department has several rows of data (each line is labeled with the department number). I need to break the departments out into individual files and email each file to the appropriate department manager. I tried to record a macro to do this but didn't have any success. The tricky part is that the number of rows for each department changes every month. How can I write a macro that will do this? Thanks!

May 2nd, 2002, 02:01 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi This would be somewhat involved in giving an explanation... Best bet: Mail me an example of your monthly book and an example of one individual file which would be created. The individual files could be automatically emailed as well. You would need to update a list of email addresses for the departments if they change. TsTom@Hotmail.com Tom Another question: Are the individual files Excel worksheets? Would you be emailing the sheets as attachments or simply the text? [ This Message was edited by: TsTom on 2002-05-02 13:03 ]

May 2nd, 2002, 02:18 PM	#3
waderw Board Regular Join Date: Apr 2002 Posts: 85	TsTom you are the man! You are really helpful. You just helped me with my macro b/c I emailed you the wb. Thanks man!