Forum Discussion
Solved
How can I create a parent control based on the text position
Hi Experts, I have exported a file containing a large amount of data where its origin has a parent-child structure. But once you open the file, this structure is shown as a single column and the ...
felipeprevente so if you have the column WITH the spaces the attached file does both give the tier level and has a macro to auto create those groups if you want
Hi mtarler, thanks for your response.
Actually, that "space" already exists. I know that I can use the group feature to collapse/expand but this is not my goal. Given that I have the spaces to determine the parent control visually, at least, I'm still having to do this manually, because there is no practical difference between A2, A3 and A4 in my example.
I don't know if I'm being clear on explaining this
Actually, that "space" already exists. I know that I can use the group feature to collapse/expand but this is not my goal. Given that I have the spaces to determine the parent control visually, at least, I'm still having to do this manually, because there is no practical difference between A2, A3 and A4 in my example.
I don't know if I'm being clear on explaining this
felipeprevente so if you have the column WITH the spaces the attached file does both give the tier level and has a macro to auto create those groups if you want
- Thanks, mtarler! it helped me a lot