There are a hundred ways to do it, but you haven't provided any information about why the simplest approach is not well suited to your problem, or described your workbook layout in sufficient detail to suggest an alternative.
Posting a workbook with some additional explanation might invite other ideas.
Bookmarks