Awesome, thank you and pleased you found it useful. I've saved so much time and produced so much better stuff over the years at work with this knowledge, so really happy to share it. Hope you enjoy the next video of on Wednesday 27th March 👍 John
Great, glad you liked it. The next video is out on 27th March.... You've got another week to refine your power query skills before the power pivot stuff kicks in 👍 John
You could do that but you wouldn't be able to use the same formula across all columns like I did as the centre across selection value only sits in one cell.
Hello Sir, I am building a spreadsheet with 7 columns and 1200 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list, column D is details with drop down, tested and working all down to 1200 rows. Column E is payments F is Income and G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C for Income code it should only allow me the income column and if selected payment from C it should allow me to enter in payments column. In income column I have 5 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two columns E & F, so that the entry don't get switched between two. Thanks a lot if you could help.. (I use Excel 2000)
Have a look at this video for data validation tips as there are a few unique ideas in here that might help you th-cam.com/video/Lb2_VKl3fW0/w-d-xo.html One idea for you is to use the method in the video to create a payments list that is effectively blank when the income is selected and vice versa for income. I think you could use the techniques in the video to do that. Good luck and thanks for watching 👍 John
In your spreadsheet, you can also set up conditional formatting that turns the cell in Column E or F black if you select Payment or Income in your data validation cell in column C. It wouldn't lock you out of entering data in either column, but it would deter you or anyone from accidentally entering a value in either column where those cells are blacked out.
all thumbs up for another excellent, valuable tutorial. Thank you so much for sharing your knowledge. Already subscribed from the 1st lesson 👏🙏
Awesome, thank you and pleased you found it useful. I've saved so much time and produced so much better stuff over the years at work with this knowledge, so really happy to share it. Hope you enjoy the next video of on Wednesday 27th March 👍 John
absolutely. Can't wait for your next tutorials. thank you for your quick, kind message BEST John@@Up4Excel 🙏
As always perfect
So glad you think so, I shall try to keep it up 👍 John
This was really helpful, just what I was looking for. When does video 3 on the power pivots come out?
Great, glad you liked it. The next video is out on 27th March.... You've got another week to refine your power query skills before the power pivot stuff kicks in 👍 John
thanks for sharing
No worries 👍 John
Very good
Thanks, glad you liked it 👍 John
well, you can use cell format across selection which will help you to avoid adding extra rows at the top
You could do that but you wouldn't be able to use the same formula across all columns like I did as the centre across selection value only sits in one cell.
How to add Quarterly column. Please guide me.
Power Query is your tool for that...it's an option on every date field 👍
how can we do this using google sheet
I don't use Google sheets but maybe someone else can answer?
Hello Sir, I am building a spreadsheet with 7 columns and 1200 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list, column D is details with drop down, tested and working all down to 1200 rows. Column E is payments F is Income and G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C for Income code it should only allow me the income column and if selected payment from C it should allow me to enter in payments column. In income column I have 5 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two columns E & F, so that the entry don't get switched between two. Thanks a lot if you could help.. (I use Excel 2000)
Have a look at this video for data validation tips as there are a few unique ideas in here that might help you th-cam.com/video/Lb2_VKl3fW0/w-d-xo.html
One idea for you is to use the method in the video to create a payments list that is effectively blank when the income is selected and vice versa for income. I think you could use the techniques in the video to do that. Good luck and thanks for watching 👍 John
In your spreadsheet, you can also set up conditional formatting that turns the cell in Column E or F black if you select Payment or Income in your data validation cell in column C. It wouldn't lock you out of entering data in either column, but it would deter you or anyone from accidentally entering a value in either column where those cells are blacked out.
Thanks Sir
@@Adam_K_W Good tip 👍