Prevent from doing double entries On Column (G & H) through VB/Macro

[pipsmultan]

Greetings to all,

i want help on my excel file plz...

i want a VB/Macro Code which Prevent from doing double entries On Column (G & H) through VB/Macro

plz see the sample image attachment

Prevent from doing double entries.jpg

i have also attach the excel file

Prevent from doing double entries.xlsx

any help will be highly appreciated

Regards

[FDibbins]

Why do you need VBA for this?

is it only 1 you dont want duplicated?

[pipsmultan]

thanks for quick reply

What I m trying to do is in my salary sheet, if someone enter "Present 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

so that "Earn Days" should not exceed from "32"

for this i need a VB/Macro Code

many Thanks

Regards

[FDibbins]

You didnt really answer my 1st question...

for this i need a VB/Macro Code

Why do you feel you need VBA for this?

[pipsmultan]

Finlay i have come with the Solution from Prevent doing double entries On Column (G & H) through Data Validation

1. Select your range starting with row 8. Say this is G8:H100.

2. Go to Data tab > Data Validation > Data Validation

3. Select Custom in Allow: field and put following formula in Formula:

=SUM($G8:$H8)<=1

You didnt really answer my 1st question...


Why do you feel you need VBA for this?

Because i thought its only possible with VBA Code


"FDibbins" thanks for ur reply

Regards