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!
Thanks!