Hi
Can you please upload a sample of your spreadsheet, it will make understanding of the issue easier and assist greatly in devising a solution for you.

Cheers