I'd like to be able to unhide rows in a spreadsheet based on a criteria. For example, I'd like to have formulas in rows 1-100, however only 1-10 would be visible to keep the unneeded rows to a minimum. However I'd like to have a cell that I could put a "50" in, and have rows 11-50 automatically unhide themselves.
This is the only way I could figure out to transfer the data from up to 100 (for example) rows to other spreadsheets, since adding rows to a range in my array-entered IF formula in my summary sheet starts to lose the additional rows from my data sheet. If you have another solution for this, it would be even better.
This is the only way I could figure out to transfer the data from up to 100 (for example) rows to other spreadsheets, since adding rows to a range in my array-entered IF formula in my summary sheet starts to lose the additional rows from my data sheet. If you have another solution for this, it would be even better.
Last edited: