I_need_help
New Member
- Joined
- May 26, 2019
- Messages
- 4
Hi folks!
I just created an account, because i need some help. I have lots of excel sheets. All are linked together. It is just a mess. So i am trying to visualize the flow of data through all sheets. I already made a table with all sheets and all dependencies. It looks like as follow:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sheet name[/TD]
[TD]Depends on[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Sheet2[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Sheet3[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Sheet3[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Sheet4[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Sheet5[/TD]
[/TR]
[TR]
[TD]Sheet3[/TD]
[TD]Sheet1[/TD]
[/TR]
[TR]
[TD]Sheet3[/TD]
[TD]Sheet5[/TD]
[/TR]
[TR]
[TD]Sheet4[/TD]
[TD]Sheet5[/TD]
[/TR]
[TR]
[TD]Sheet5[/TD]
[TD]Sheet6[/TD]
[/TR]
</tbody>[/TABLE]
The real list is much larger. I am looking for some way to visualize the flow. Some kind of workflow or flowchart. I tried making my own in Paint. Please dont judge my bad painting skills please
The real list is much larger (hundreds of records). Making such flow by hand isnt really an option. So i am looking for some kind of script (VBA?) to go from the list in Excel such kind of workflow. Can someone help me? Does anyone has a great solution to get more insight in the data flow through all sheets?
I just created an account, because i need some help. I have lots of excel sheets. All are linked together. It is just a mess. So i am trying to visualize the flow of data through all sheets. I already made a table with all sheets and all dependencies. It looks like as follow:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sheet name[/TD]
[TD]Depends on[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Sheet2[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Sheet3[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Sheet3[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Sheet4[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Sheet5[/TD]
[/TR]
[TR]
[TD]Sheet3[/TD]
[TD]Sheet1[/TD]
[/TR]
[TR]
[TD]Sheet3[/TD]
[TD]Sheet5[/TD]
[/TR]
[TR]
[TD]Sheet4[/TD]
[TD]Sheet5[/TD]
[/TR]
[TR]
[TD]Sheet5[/TD]
[TD]Sheet6[/TD]
[/TR]
</tbody>[/TABLE]
The real list is much larger. I am looking for some way to visualize the flow. Some kind of workflow or flowchart. I tried making my own in Paint. Please dont judge my bad painting skills please


The real list is much larger (hundreds of records). Making such flow by hand isnt really an option. So i am looking for some kind of script (VBA?) to go from the list in Excel such kind of workflow. Can someone help me? Does anyone has a great solution to get more insight in the data flow through all sheets?