Check value in a cell vs Mid value in another
Solved/Closed
student of VBA
-
Apr 15, 2011 at 08:30 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 15, 2011 at 09:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 15, 2011 at 09:55 AM
Related:
- Check value in a cell vs Mid value in another
- Insert check mark in word - Guide
- Check soft - Download - Finance
- How to check pc power consumption in windows 11 - Guide
- Vba check if value is in array - Guide
- Speaker check code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 15, 2011 at 09:55 AM
Apr 15, 2011 at 09:55 AM
Hi Student of VBA,
Sorry to disappoint you, but you don't need VBA for this. :(
I assume row 1 is used for header, so select B2.
Goto top menu > data > validate.
On the dropdown list "Allow" select the bottom option (manual adjust?)
Type in this formula:
Drag cell B2 down as far as needed and select "format only" from the small white square. The small white square appears when done dragging.
Don't understand the following:
quote
Please also note that column B needs to be stripped of 0 for the nine months check and then included for the last three months.
unquote
So you want 04 to be 4 and 10 to be 010???
Best regards,
Trowa
Sorry to disappoint you, but you don't need VBA for this. :(
I assume row 1 is used for header, so select B2.
Goto top menu > data > validate.
On the dropdown list "Allow" select the bottom option (manual adjust?)
Type in this formula:
=MONTH(B2)<>A2On the right most tab (error message) of the validate window you can type in the error message.
Drag cell B2 down as far as needed and select "format only" from the small white square. The small white square appears when done dragging.
Don't understand the following:
quote
Please also note that column B needs to be stripped of 0 for the nine months check and then included for the last three months.
unquote
So you want 04 to be 4 and 10 to be 010???
Best regards,
Trowa
