It sounds like you are dealing with something that could be fairly straight forward.
Are you able to add some sample data or a packed workbook? This would allow us to help you out much quicker.
I have found a solution!
Michael, what is the solution that you found?