Extracting rows into a self-populating table on another worksheet - please help!

Risk Heat Map Draft 5.xls

Hi there,

I've been googling and fiddling with formulas for hours upon hours just trying to get this to work, but for some reason it keeps telling me I have a circular reference. Can anyone help?

In the attached file I'm trying to get it so that in the worksheet "1-1" all rows from the table in the worksheet "Risk Table" are extracted when they have a "1/1" value in the "calc1" column, but it's telling me that this is crcular reference. I even tried it on the same spreadsheet, but couldn't get that to work either.

The idea is that I will create a worksheet for each value of "calc1", which is linked to how the rows are organised in the first tab's heat map. Then I can insert hyperlinks to each worksheet so that you can click on certain cells in the map, and be shown all the "risks" that it's referring to. Let me know if you think I'm doing this terribly or there's an easier way you can think of, as I was given the task of trying to create a Risk Map and this was the best I could think of (after giving up on Bubble graphs).

Thanks for any help!!

David

That way I get an #NAME? error, am I doing something wrong?

Thanks so much for your help!

Thanks, Fotis! That's perfect!!

I've got another question now about linking to hidden sheets, but I'll ask about that in a separate topic.

Thanks,
David