Elegant solution preserving info
I'm using named ranges to group persons listed in Col A. I'd like to be able
to transfer these named ranges to a new workbook and of cause the names listed
in Col A.
I could save the groupnames and rangedefinitions in a sheet but that's a lot of
extra updating if it's possible to reference and copy the ranges directly from
Excel.
Anyone knows how to do that?
A secondary issue: when I remove a person I end up with an empty row (which is
necessary due to the design I'm using right now). This empty row continues beeing
part of any group defined earlier. Using this row for another person might place
him/her in a wrong group.
I'm uncertain whether deleting the row always will update the ranges correctly,
likewise inserting a new row, how's it affecting the ranges as one person may
participate in many groups.
I'm looking for a simple and secure method to handle groups. Maybe the answer
is not using named ranges.
Any suggestions ?
Thanks in advance!
|