Good morning,
I have a workbook with various sheets containing extractions, user inputs, and various formulas. In Sheet2, I have a report that is generated based off of the information within some of these other sheets. The length of this report is currently maintained manually with a filter. The filter field is a helper that uses a formula to decide if the row is valid or not (1 or 0). What I would like, is to have a little bit of background VBA code that will envoke the filter whenever the values in this filter field change. The filter criteria is always 1, the row header is always T12 and the filter range is always T12:T141 (all within Sheet2). It doesn't seem like this would be that hard... but I can't make it work. Thoughts?
Thanks,
I have a workbook with various sheets containing extractions, user inputs, and various formulas. In Sheet2, I have a report that is generated based off of the information within some of these other sheets. The length of this report is currently maintained manually with a filter. The filter field is a helper that uses a formula to decide if the row is valid or not (1 or 0). What I would like, is to have a little bit of background VBA code that will envoke the filter whenever the values in this filter field change. The filter criteria is always 1, the row header is always T12 and the filter range is always T12:T141 (all within Sheet2). It doesn't seem like this would be that hard... but I can't make it work. Thoughts?
Thanks,