blackie42
12-21-2016, 07:42 AM
Hi
On sheet called 'Bank transactions' in cell B7 (static) I have the words 'Bank transactions'
Row 8 is blank
Row 9 has narrative 'Date' in A, 'Narrative' in B & 'Value in C' - don't need to see row 8 or 9
I'd like to be able to hide these rows up to where column B has 'Uncleared Bank transactions'
This will vary depending on the number of transactions appearing between B7 and B? (i.e. wherever 'Uncleared Bank Transactions' appears)
Please see attached - need to highlight yellow area which varies each day - highlight one row too much as needs to still say
Uncleared Bank Transactions with cheques and other uncleared items listed
Any help very much appreciated
thanks
Jon
On sheet called 'Bank transactions' in cell B7 (static) I have the words 'Bank transactions'
Row 8 is blank
Row 9 has narrative 'Date' in A, 'Narrative' in B & 'Value in C' - don't need to see row 8 or 9
I'd like to be able to hide these rows up to where column B has 'Uncleared Bank transactions'
This will vary depending on the number of transactions appearing between B7 and B? (i.e. wherever 'Uncleared Bank Transactions' appears)
Please see attached - need to highlight yellow area which varies each day - highlight one row too much as needs to still say
Uncleared Bank Transactions with cheques and other uncleared items listed
Any help very much appreciated
thanks
Jon