sikander1986
Board Regular
- Joined
- Sep 6, 2008
- Messages
- 66
I want to create a macro which will help me to solve my problem on a daily basis. As I have to do this all work manually to remove the unwanted mistakes in the file & reduce the wastage of time.
I have a number is column H & based on this column only other columns should work. If column H is filled then Column D, Column E, Column F & column L should not be blank. And if these 4 columns are blank then message box should popup saying as column D can’t be blank and so on for other columns. And without filling it up the required columns the file should not be allow to save.
In the Column L I have the validations whose source of date is in column BZ from BZ5 to BZ10. If in column L gets updated with any value other than values from BZ5 to BZ10 then it should get message box as column L can’t be different.
And I have date in the column A & based on this date the month should get updated in the column C automatically in the format of mmm’yy (i.e. Aug’11) without the use of any formula. And in the same manner the column B should get updated with the date of Monday. For example today the date is 4-Aug-11 then date is column B should be 1-Aug-11. I mean to say whatever the date may be in the column A, That week’s Monday date should reflect in the column B.
And if Column AE is “Closed” then column AB & AC should be blank automatically & Column Z should not be blank if column AE is closed & column AD should be not blank if column AE is closed & should be filled with a date. If these conditions are not getting met then message box should popup.
IF column Z is equal to the values of column CA i.e. from CA5 to CA10 then column X should be Zero automatically. And if the column Z value is not equal to the values of CA5 to CA10 then column X should not be Zero.
Thanks for your help in advance. pls help me as i want to get this code without the use of command button.
I have a number is column H & based on this column only other columns should work. If column H is filled then Column D, Column E, Column F & column L should not be blank. And if these 4 columns are blank then message box should popup saying as column D can’t be blank and so on for other columns. And without filling it up the required columns the file should not be allow to save.
In the Column L I have the validations whose source of date is in column BZ from BZ5 to BZ10. If in column L gets updated with any value other than values from BZ5 to BZ10 then it should get message box as column L can’t be different.
And I have date in the column A & based on this date the month should get updated in the column C automatically in the format of mmm’yy (i.e. Aug’11) without the use of any formula. And in the same manner the column B should get updated with the date of Monday. For example today the date is 4-Aug-11 then date is column B should be 1-Aug-11. I mean to say whatever the date may be in the column A, That week’s Monday date should reflect in the column B.
And if Column AE is “Closed” then column AB & AC should be blank automatically & Column Z should not be blank if column AE is closed & column AD should be not blank if column AE is closed & should be filled with a date. If these conditions are not getting met then message box should popup.
IF column Z is equal to the values of column CA i.e. from CA5 to CA10 then column X should be Zero automatically. And if the column Z value is not equal to the values of CA5 to CA10 then column X should not be Zero.
Thanks for your help in advance. pls help me as i want to get this code without the use of command button.
