From what you've described, Bonny's solution should work for you. Can you upload a dummy spreadsheet showing exactly what you are doing and what you expect? (Go Advanced>Manage Attachments)