parent-child

Hi wonderful people. I'm hoping you may be able to help. Apologies if this has already been solved elsewhere. I have HR data like the inout data table below where I have manager and subordinate employee numbers. I'd like to find some VBA code to output the table to the right below. In...

Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...

Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...

I have a spreadsheet of records from 2 database tables in Excel (one row per joined record). I want to be able to outline and hide the detail part. I can't seem to do it. I don't need or want subtotals or anything like that. I have (simplified): Account Name Date Amount 123...

Hello, I am working in Excel and I am not advanced user of VBA, but I think I need VBA for this problem. Zippyshare.com - primeeeer.xlsx If there is anyone who might help, I would really appreciate it. So, the problem is, there are processes, and they depend one of another, depending on the...

Hi everyone. I've found threads that cover similar questions to the one I have, but none which touch upon exactly what I'm looking for. This is also the first time I've posted in here, so I apologize if I do anything incorrectly. What I'm trying to do is create an additional column within...