Thank you for all your help. I had to enable the analysis tool pack for the eomonth function to work but once i did that the code worked exactly as i needed it! definataly beats entering all the sheet names and dates in by hand.


one last thing, as im sure you can tell by my number of posts i am new to this forum and cannot figure out how to mark this task as solved or to contribute to your reputation. I am on my work computer and we do not have up to date flash players or java apps. I can follow the directions for both, but i do not see a button to contribut to your reputation or an edit button for the original post.....


thanks again for you help.