Suggest you attach a workbook with the minimum in it to show what you're wanting to do, with realistic data. This will answer a lot of unknowns and save us guessing.
In addition (quite important), tell us what version of Excel you're using.