Hide / Show lines Based on Criteria

Hi all,


Is it possible to hide / show lines or cells based on another cell value but without using VBA ?

Imagine i have:

A1 =
B1 = x
C1 =

Imagine i have an x on one of those options above

If B1 = x then show line 10 to 30 for example...



Cheers

The short answer is no.

Can you elaborate on what you are trying to do?

Brad.

Originally Posted by bradles

The short answer is no.

Can you elaborate on what you are trying to do?

Brad.

The problem is that i cant use VBA cause this is a pre-formated document that will be sent to my clients.

The idea is that when they select one of the 3 Options

A1 B1 C1 ( they will have to mark with an x )

They will have different fields to fill in

Originally Posted by rwgrietveld

You could using a standard filter.

make a helper column with the following function: =IF(AND($B$1="x",ROW()>=10,ROW()<=30),1,0)
Filter this column where 1 would give you line 10-30

Well thanks for the formula, but wouldn't this implicate that the end user "my client" had to use the filter function ?

I want a user friendly, most of my clients dont even know how to work with excel.

Thanks

PS:

Please Login or Register  to view this content.

Im in portugal so i guess the function will look like the above with the ; instead of the , ?


Cheers

It sounds to me like this would be a VBA solution.

Are you aware that you can password protect your vba code. Not that password protection in excel is absolutely infallible.

If you are worried that it won't work if the user doesn't allow VBA there are ways around this. Eg, Have an On Close event fire to show a worksheet that instructs them that "this program will not work unless you allow macros". This resets every time the workbook is closed, just in case they open it in future and choose not to allow macros.

Would love to give you better news...hopefully someone out there has it for you...but in my 15 years of experience with Spreadsheets, this one sounds like it requires VBA.

Brad

Originally Posted by bradles

It sounds to me like this would be a VBA solution.

Are you aware that you can password protect your vba code. Not that password protection in excel is absolutely infallible.

If you are worried that it won't work if the user doesn't allow VBA there are ways around this. Eg, Have an On Close event fire to show a worksheet that instructs them that "this program will not work unless you allow macros". This resets every time the workbook is closed, just in case they open it in future and choose not to allow macros.

Would love to give you better news...hopefully someone out there has it for you...but in my 15 years of experience with Spreadsheets, this one sounds like it requires VBA.

Brad

Thanks Brad for the reply, yeah i also figured this wouldn't be possible without VBA.
Guess i have to find another way around this.