I've got a fairly complicated workbook. The lead worksheet picks up matching cell info in several other worksheets. I'd like to have a duplicate of this lead sheet that, instead of returning the "sum" formula result, would return a list of which worksheets in the formula have a value that is not zero.
Basically, I need to know which worksheets are producing values for each cell. More like a reference page. I could see that cell D15 in my lead worksheet is picking up non-zero values in 3 of the other worksheets because the cell would list either the worksheet names or some other cell that would identify the worksheets.
Does this make sense? I'm not even sure where to begin. Lookup or some kind of table? I really have no idea, though I'm positive there's a way to do this. Thanks.
Basically, I need to know which worksheets are producing values for each cell. More like a reference page. I could see that cell D15 in my lead worksheet is picking up non-zero values in 3 of the other worksheets because the cell would list either the worksheet names or some other cell that would identify the worksheets.
Does this make sense? I'm not even sure where to begin. Lookup or some kind of table? I really have no idea, though I'm positive there's a way to do this. Thanks.