Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Write a macro to split out depts into individual files

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!



  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •