M
Mike
Hi there,
I've been trying to use DV to provide additionally security on employee
vacation schedules using excel 2007. I have encountered 2 items to which I
can't seem to find any fix for.
1) One DV that works very well (via custom) is for the formula
R13=SUBTOTAL(109,D13:Q13) where D:Q are number of days taken off. What I am
finding is that when I enter numbers in cells D:Q, the validation no longer
works on cell R and anything can be entered in cell R - which was formerly
protected. Any thoughts???
2) I am trying to apply a DV to a cell with the formula
=VLOOKUP(A67,Master,3,FALSE), where Master is a name range on a different
tab, so that only this formula can be used in the cell. I enter the same
formula under DV-custom-source, but nothing seems to work and anything can be
entered in the cell.
If anoyone has thoughts or suggestions on either or both, I would definately
be thankful.
Much appreciation
Mike
I've been trying to use DV to provide additionally security on employee
vacation schedules using excel 2007. I have encountered 2 items to which I
can't seem to find any fix for.
1) One DV that works very well (via custom) is for the formula
R13=SUBTOTAL(109,D13:Q13) where D:Q are number of days taken off. What I am
finding is that when I enter numbers in cells D:Q, the validation no longer
works on cell R and anything can be entered in cell R - which was formerly
protected. Any thoughts???
2) I am trying to apply a DV to a cell with the formula
=VLOOKUP(A67,Master,3,FALSE), where Master is a name range on a different
tab, so that only this formula can be used in the cell. I enter the same
formula under DV-custom-source, but nothing seems to work and anything can be
entered in the cell.
If anoyone has thoughts or suggestions on either or both, I would definately
be thankful.
Much appreciation
Mike