You cannot imply a hierarchical relationship between excel worksheets. Each
one is independent. What you can do is use a naming convention or a color
scheme to relate them. You main worksheet can be Data and the ‘sub’
worksheets could be s1Data, s2Data, s3Data. If you wanted subs to the subs,
say s1Data, that could become s1s1Data, s1s2Data, ect.
Can you create a hierarchiacal relationship with Multiple Workbooks?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
