Hi Richard, wlecome to the forum.
Yes, your idea is possible and if you execute an extended search on this forum you'll find enough, will probably need a little tweaking to completly customize it to your needs.
You haven't mentioned the Excel version you're using and how far your VBA skills go, this last one for the tweaking of the vba code you may find.
Give it a search and then let us know. Re-inventing the wheel is not always really necessary
Yes, your idea is possible and if you execute an extended search on this forum you'll find enough, will probably need a little tweaking to completly customize it to your needs.
You haven't mentioned the Excel version you're using and how far your VBA skills go, this last one for the tweaking of the vba code you may find.
Give it a search and then let us know. Re-inventing the wheel is not always really necessary