VB/Macro Required for Stoping Same Number at same time

Greetings to all,

i want help on my excel file plz...

i want a VB/Macro Code which can do the following...

0 0
1 0
0 1

i just want to enter only the these "values" in the cell of G9 & H9 only and down below by dragging

plz see the sample image attachment

Salary VB Code Required.jpg


i have also attach the excel file

Salary Sheet.xlsx

any help will be highly appreciated

Regards

Could you please explain the logic of what you are trying to do. Also in the future try to make your post titles a bit more unique.

Please Login or Register  to view this content.

Regards, TMS

thanks for your Reply and your good guidance for future

I have Attach new copy of my excel file which i hope it will give you clear understanding of my Problem

Prevent from doing double entries.xlsx

Prevent from doing double entries.jpg

What I m trying to do is in my salary sheet, if someone enter "Present Days 31" and he got "leave (Zero)" and he have "1 Leave Allowed" than his total "Earn Days" will become "32"

& same if he got "leave (Zero)" and he have "1 Leave Allowed Not Availed" than his total "Earn Days" will also become "32"

But Actual Problem is i want to Prevent from doing double entries On Column (G & H) through VB/Macro

for this i need a VB/Macro Code

many Thanks

Regards

hope i am making my self understanding

No, not at all. You asked for something, you were given what you asked for. Then you ask for something completely different.

Your updated example makes no sense to me. At least I understood the True/False bit, which is still indicated as a requirement in the new example.

I'm sorry, it's late on Sunday, and I'm done.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)