HELP! Integrated Sheet showing info based on certain criteria

[Gisela1209]

Hi There,

I know my way somewhat around excel (not at expert level though) and have successfully build a lot of sheets to make my life easier, but I am battling with one specific sheet that I want to build.
I have the idea in my head, but just not sure how to go about creating the sheet and how to look for the help needed.

I have to create risk assessments that is task and scope based, but it is quite a lot of work to add and take out information the whole time. So what I essentially want to do, is to have a sheet with all my information on in a table format, and to have a tick box next to each line. And then have a second sheet, which is my preview sheet. Depending on the tick boxes I tick, I want the second sheet to automatically pull the ticked boxes data through.

If I then need to change the scope and tick different boxes, then the second sheet needs to update and show the new data.

Not sure if I am explaining it correctly.

Any help would be appreciated. I would do my own research on how to do it, but I don't know what terms to search for that will give me the excel tools that I need to use. And I would build the sheet myself, but I don't know where to start to integrate the sheet.

Regards
Gisela

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.