Write a macro to split out depts into individual files

Powersmj

New Member
Joined
May 1, 2002
Messages
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!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top