It seems you are very knowledgeable in MS Excel. Hello Sir, I am designing a spreadsheet daily data entry from bank statements. Its designed with 7 columns and 2500 rows, Column A is just a reference column, B is dates column and they all work as it should, Now this is where I need your input Sir, Column C is Data validation drop down with 60 codes of expenses and four with income like, sales, Finance, Tax refund and Visa Cash Back. Column D is again a drop down that works with in coordination with Column C, Now when if I select from column C for expanses I want only Expanses column to be active (Which is column E) and If I select from column C for Income it should only allow me to enter in Column F (Which is Income column) Column G is balance column and it works fine, I want to use custom validation to allow only to designation Columns E & F, I have replicated YES No string but it selects only two of one name values. It will be appreciated if you could help to setup custom Validation in column E & F, Thanks a lot and I am using Excel 2000.
![Coheed and Cambria - Searching for Tomorrow [Official Video]](http://i.ytimg.com/vi/hDsYGLbmadg/mqdefault.jpg)
🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/f5p
I feel like this should've been taught at schools, instead everyone just used pie chart all the time. Great video!
thanks you can we get a part 2/more extended version?
thanks for watching always I'll keep it noted :)
You’re still my go to man for all things excel. Great vid.
thank you kenji
Hi man... Lots of Love from India 🇮🇳
It seems you are very knowledgeable in MS Excel. Hello Sir, I am designing a spreadsheet daily data entry from bank statements. Its designed with 7 columns and 2500 rows, Column A is just a reference column, B is dates column and they all work as it should, Now this is where I need your input Sir, Column C is Data validation drop down with 60 codes of expenses and four with income like, sales, Finance, Tax refund and Visa Cash Back. Column D is again a drop down that works with in coordination with Column C, Now when if I select from column C for expanses I want only Expanses column to be active (Which is column E) and If I select from column C for Income it should only allow me to enter in Column F (Which is Income column) Column G is balance column and it works fine, I want to use custom validation to allow only to designation Columns E & F, I have replicated YES No string but it selects only two of one name values. It will be appreciated if you could help to setup custom Validation in column E & F, Thanks a lot and I am using Excel 2000.
Ask ai
@@Panda-gu2yb Ask Who, who is AI Chinese Panda GAY
@@johnboffin476 ask chat gpt AI
Kenji, are you excellent at this! 😊
PS how do we highlight a specific gridline? (For example 0 or 100)
Great video thanks.
Hi Kenji, I couldn't control my laughter after seeing that @18 😂 He is a very famous actor from the state where I am from (Tamil Nadu, India)
ahahaha that's great to hear you recognized him XD
Everyone from Tamil Nadu recognizes him..LOL@@KenjiExplains
Sir, can you help me formulate my template in work 😢
Nice way to explain
thank you!
Wow really helpful!!
Glad you think so!
This is great
thank you sir!
Awesome
thank you!
0:18 😂 he is a actor from tamilnadu (india)
👍👍👍
Cheers!
Hey hi how are you doing 👋🏻😊
Hey all good thank you! Hopefully you too :)
@@KenjiExplains yup somehow 😁