B
buzzandbeyond
Hi,
I am trying to hide rows with a specific value.
In my sheet I have three columns:
Date - The manually inputted date
Today - 1 Month - 'TODAY() -31' (this column will be hidden)
In Range? - an IF statement to say "HIDE" or SHOW" (this column will
be hidden)
I am looking to hide all the rows where Hide shows in the In Range?
column. I would also like this to run on opening the document
Any advice is gratefully received as my vba skills are almost non
existent.
cheers
Dave
I am trying to hide rows with a specific value.
In my sheet I have three columns:
Date - The manually inputted date
Today - 1 Month - 'TODAY() -31' (this column will be hidden)
In Range? - an IF statement to say "HIDE" or SHOW" (this column will
be hidden)
I am looking to hide all the rows where Hide shows in the In Range?
column. I would also like this to run on opening the document
Any advice is gratefully received as my vba skills are almost non
existent.
cheers
Dave