Hi,

I have seen lots of examples but can't get any to work - I have a job
sheet with approx 60 rows - the rows contain data applicable to
various types of job.

What I want to do is have the user select which job type they are
completing, and then automatically hide/unhide the rows that aren't
relevant to that job.

I have added a hidden column A with an If statement that returns 1 or
0 depending on if the row should be shown/hidden 1 to show - 0 to
hide)based on what the user picks as the job type.

Can anyone help with some sample code and maybe advice on how I can
get this to work ?

Thanks..
Nick