Display of row depending on values (yes / blank) in cell of row upon opening of sheet

Jens Christian Wulff
Jens Christian Wulff used Ask the Experts™
on
Need a VBA script to run upon opening of sheet giving the user a specifc selecton of rows based on content of one cell in every row.

Thanks for all the expert advice!! BR
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
Sounds like you need to use AutoFilter. Attach an example workbook to help better understand your requirements.

Author

Commented:
Thanks Roy. Will do ASAP.
Software Team Lead
Commented:
Yes, as what Roy suggested, something like this:

Range("$A$1:$H$5").AutoFilter Field:=3, Criteria1:="Your Text"

Open in new window


further reading:

Range.AutoFilter Method (Excel)
https://docs.microsoft.com/en-us/office/vba/api/Excel.Range.AutoFilter
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Thanks Roy & Ryan,

Touch’e - this will work like a charm. I need to dive into the programming manual a lot more. Have a great weekend both.
Best Regards
Jens
Roy CoxGroup Finance Manager
Commented:
Pleased to help. If you have several words you may need to use an array, which is why I wanted to see an example.

Author

Commented:
So it is actually (sry for my lack of insight) possible to build and operate a multidimensional array with different autoformats build into each secondary array! That’s neat!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial