Hi,

For sure there is a solution with Excel ... it will probably require
some VBA coding.
Your description is way too vague for any of us to give you a hand ...