One of the interesting things about Excel is that there are often multiple ways to accomplish end goals. You can tell that's the case because often even after a question has been answered somebody else will come along and offer an "alternate take" or "alternate way to look at this."
I mention that because it would help here if we could get a more in depth understanding of what you're actually trying to accomplish. Could you back up and just describe the "application" or the "business process" or whatever it is that has given rise to your question.
And if you could accompany that with a copy of the workbook you have developed so far, that would go a long way toward helping us understand your situation. Possible? Just make sure there is no private or confidential info in your workbook.