Zafar, you've read the forums, right? You've seen all those posts saying "Please post a packaged workbook..." right? So, please post.....
I second that. No offense intended, but based on only a text description, it is very difficult to provide a solution.