Organizing multiple sheets into one overview sheet

pasjauo

New Member
Joined
May 1, 2017
Messages
44
Hey guys

We have at work a risk management excel file, where we post and update our risks accordingly. We are always improving on our work (until we realise we should use a SaaS product) and we are trying to include risk evaluation. Every risk has its own sheet and in the bottom we have made an evaluation table where they can edit the risk during the year if something happens. The risks often only changes once, but can possibly also change 2-3 times. All this is working fine, but we are missing the great overview or even perhaps a report when necessary.

Do you have any ideas on how to organize a risk evaluation sheet where the information comes from different sheets and has to be easy to organize? In theory I could do a code to include lines if they are not empty but how will I manage the multiple entries in one sheet?

I don't mind including lots of VB (i can always ask here for help if it too advanced for me, god bless) but of course I need to make sure that I am not the only one who can update and eventually improve the file.

Thanks in advance! :)
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,122,511
Messages
5,596,581
Members
414,079
Latest member
Frills

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top