Monthly data validation with colour

[Casid]

Hello Everyone,
I need assistance on a task I do every months. Could someone please help me define a formula to use such that when I change the month( Filled in yellow) using data validation, all the corresponding amounts for that month changes as well. See attached..

Thanks.

 

[NARAYANK991]

Hello Everyone,
I need assistance on a task I do every months. Could someone please help me define a formula to use such that when I change the month( Filled in yellow) using data validation, all the corresponding amounts for that month changes as well. See attached..

Thanks.

Hi ,

See the uploaded file.

Narayan

 

[Casid]

Hi ,

See the uploaded file.

Narayan

You dont know how happy I am right now. I am really grateful and thanks alot. I am really challenged and I wanting to be a guru like you.

Please how do I get to know more on. Anywhere in this forum where I can practice?

 

[NARAYANK991]

Hi ,

The best places to improve your expertise in Excel are forums like these.

Chandoo has innumerable blog posts on various aspects of Excel , and if you go through his tutorials and the questions in this forum , you should soon find yourself improving.

Go through those questions which interest you , see whether you can answer them , and then see how others have answered them.

Once you have spent six months doing this regularly , you will find that you are able to answer questions yourself.

Narayan

 

[Casid]

Hi ,

The best places to improve your expertise in Excel are forums like these.

Chandoo has innumerable blog posts on various aspects of Excel , and if you go through his tutorials and the questions in this forum , you should soon find yourself improving.

Go through those questions which interest you , see whether you can answer them , and then see how others have answered them.

Once you have spent six months doing this regularly , you will find that you are able to answer questions yourself.

Narayan

Thanks a lot. I am put that in mind.