Hide data in selected fields

[hel]

I have attached a worksheet with the matters I need help on indicated.
It in simple terms asks for a way to have data in cells not show when a list box selects months.
Any assistance appreciated

Hel

[hel]

sorry to bring this forward again but if someone can help it would be appreciated

Hel

[foxguy]

Hel;

I'm including a workbook that does what you want for #1. I'm not sure what you mean for #2. I'm guessing that you mean; if you select a Sale Month that is before the Start Month, that is an error. If that's not what you mean, let me know.

[hel]

Thank You.
Exactly what I need.
Only problem is when the start date is say November and the Sale date is March
If you could look at this please it would be appreciated

Many thanks

Hel

[foxguy]

Hel;

What do you want to happen when Start Date is Nov and Sale Date is Mar?

[hel]

Thanks for your prompt reply.
I need to see the columns associated with the months.
These figures are interest payments

Hel

[foxguy]

Are you saying that if Start Date is Nov & Sale Date is Mar, you want to see months Mar-Nov, the same as if Start Date is Mar & Sale Date is Nov?

[hel]

in a word yes if it possible

Hel

[foxguy]

OK, here is a revised file.

[hel]

Thanks for you file.
Not quite right yet.
If you use Nov and start and March as sale date
It deletes Dec, Jan & Feb and it shows Apri to Oct

In this case I was looking to see only Nove, Dec Jan & Feb

regards

Hel

[foxguy]

Too tired tonight. Work on it 1st thing in the morning.

[hel]

Many thanks

Hel

[foxguy]

Here's the updated version Copy of example 2.xls

I have a feeling that this is not the result you want.
When you select Nov as Start Date and Feb as Sale Date, I imagine that you want Jan to be after Dec, but your data has it in front of Dec.

[hel]

Many Thanks for your efforts that is exactly what I am after.
Appreciate your time and effort

regards

Hel

[foxguy]

Are you saying that the copy of Example 2.xls is exactly what you are after. Or are you saying you want Jan after Dec?

[hel]

Sorry for confusion.
What you have done is perfect and exactly what I want

Again my thanks

Hel

[hel]

Thanks for your assistance

regards

Hel

[foxguy]

My Pleasure