Actually, if you wan the data to be dynamic... there's a bit more to it than it seems. You need to use Named Ranges to make it properly dynamic, as I did in Post 14. Take a look at what I set up there (CTRL-F3 to view/edit the named ranges in that post). If you need any more help, shout.

For now, though...

You're welcome. Thanks for letting us know that you got an answer.



Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.