Robert, welcome to ExcelFox community.

Can you post a sample file on a file sharing site, and post the link here. It would be better to have a look at the file, and propose a solution.