Hi, sorry for the lousy description but I've got no idea what the function is called for what I'm trying to achieve. 
I have one sheet in a work book that reports power outages in terms of current and completed outages and I'm hoping to create another sheet which reports selected data when there is - or has been - an outage.
So, if the power goes out, I'd like the second sheet to report that it's off (or has been off and is now resolved). I don't want it to report anything that hasn't gone off. There may be mutliple outages at one time.
Please note that I already possess the code to calculate the outage durations*, but I was hoping there was a way to convince Excel to display separately only the lines that have data in the active or completed outages columns PLUS pick up some selected additional data from the same row. (Localities affected, zones, etc.)
The sheet would need to update with any new outages that were recorded from that point forward. (And just to really make it annoying, I'll probably need some way to get them off that report again once they've passed a certain time/date period, such as 'two weeks later' or whatnot.)
Can this be done automatically without resorting to VBS? (I'm not allowed to run scripts even if I understood them ... which I don't!)
If so, what is this kind of selective reporting called? For all I know there's a zillion posts on here about that topic (and in that case, I'm very happy to hunt for them), in which case I apologise for starting yet another thread. Unfortunately, without knowing what to search for I've had no luck finding anything.
Thanks, and apologies again if this was a stupid question.
* The advice I got from here for that sheet worked brilliantly - thanks again! It took me three days to finally (mostly) wrap my head around what the code was doing, and even once I got a grip on it there's no way I could come up with it on my own, but wow! What a concept!
I have one sheet in a work book that reports power outages in terms of current and completed outages and I'm hoping to create another sheet which reports selected data when there is - or has been - an outage.
So, if the power goes out, I'd like the second sheet to report that it's off (or has been off and is now resolved). I don't want it to report anything that hasn't gone off. There may be mutliple outages at one time.
Please note that I already possess the code to calculate the outage durations*, but I was hoping there was a way to convince Excel to display separately only the lines that have data in the active or completed outages columns PLUS pick up some selected additional data from the same row. (Localities affected, zones, etc.)
The sheet would need to update with any new outages that were recorded from that point forward. (And just to really make it annoying, I'll probably need some way to get them off that report again once they've passed a certain time/date period, such as 'two weeks later' or whatnot.)
Can this be done automatically without resorting to VBS? (I'm not allowed to run scripts even if I understood them ... which I don't!)
If so, what is this kind of selective reporting called? For all I know there's a zillion posts on here about that topic (and in that case, I'm very happy to hunt for them), in which case I apologise for starting yet another thread. Unfortunately, without knowing what to search for I've had no luck finding anything.
Thanks, and apologies again if this was a stupid question.
* The advice I got from here for that sheet worked brilliantly - thanks again! It took me three days to finally (mostly) wrap my head around what the code was doing, and even once I got a grip on it there's no way I could come up with it on my own, but wow! What a concept!
