Auto-update functions

Hi all. Complete n00b here, so even though this has probably been done a thousand times elsewhere, I don't even know enough to know what I would search for. Thanks in advance for your patience.

I am working on a risk register, where there will be a few detailed risk registers over several worksheets, and a frontpage which I want to autopopulate with any risks over a certain rating. What I want to know how to do is update the frontsheet of a workbook dependant on the values in cells on another sheet. What sort of formula do I need here? I thought maybe an IF, which I don't know how to use, translating the following into Excelese:

IF any cell from range E1 - E5 in worksheet 2 has value > 15, then line of that cell copied and inserted here

Let me know how I should do this, or if there's anything else you need to know to help.

Thanks

Try this

Paste this in the worksheet module for Sheet2

Please Login or Register  to view this content.

With a copy of your workbook

To get the correct w/s module

Right click on the tab for "Sheet2" Click View code then paste all of the code in the resultant pane.

Change Sheets("Sheet1") to suit a spare sheet in your workbook.

I have attached a very simple demo workbook, change a value on "Sheet2" and see the result in "Sheet1", repeat as often as you need and watch the result.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.