Please upload a sample of your work book to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here. Be careful with any sensitive data. Pleae also post the code that you have already created. We'll see what we can do from there.
In the meantime, have a look my test work book at the following link:-
The code attached to the work book is one that I wrote for another Poster a few months ago and I believe that it may work for you also as the query was similar to yours.