schtengraby
New Member
- Joined
- Nov 12, 2021
- Messages
- 2
- Office Version
- 2019
- Platform
- MacOS
Dear All,
I have groups of (active) worksheets between other (passive) sheets that are acting as delimiters (these delimiter sheets are named things like: 'A-start', 'A-end', 'B-start', 'B-end' etc.) and I need to get a list of the names of the sheets between each 'start' and 'end' delimiter. The sheets between the delimiters will be moved in and out of the groupings, hence the need to get a dynamic list as they move about.
So for example, if sheets 'Tom', '****' & 'Harry' are between sheets 'A-start' & 'A-end'
And sheets 'Alice', 'Barbara' & 'Claire' are between sheets 'B-start' & 'B-end'
I need a list of 'Tom', '****' & 'Harry' in Column 1 and 'Alice', 'Barbara' & 'Claire' in column 2
Then if 'Tom' moves to between 'B-start' & 'B-end' it needs to dynamically move over to column 2
Hope that explains - thanks a lot for your help.
Really appreciate it!
Schten
I have groups of (active) worksheets between other (passive) sheets that are acting as delimiters (these delimiter sheets are named things like: 'A-start', 'A-end', 'B-start', 'B-end' etc.) and I need to get a list of the names of the sheets between each 'start' and 'end' delimiter. The sheets between the delimiters will be moved in and out of the groupings, hence the need to get a dynamic list as they move about.
So for example, if sheets 'Tom', '****' & 'Harry' are between sheets 'A-start' & 'A-end'
And sheets 'Alice', 'Barbara' & 'Claire' are between sheets 'B-start' & 'B-end'
I need a list of 'Tom', '****' & 'Harry' in Column 1 and 'Alice', 'Barbara' & 'Claire' in column 2
Then if 'Tom' moves to between 'B-start' & 'B-end' it needs to dynamically move over to column 2
Hope that explains - thanks a lot for your help.
Really appreciate it!
Schten