M
Mucah!t
Hello all,
I'm looking for a way to filter data when a person enters a date in a
given cell.
Actually it doesn't need to be a cell, if it can be done with an
inputbox, that's fine.
In the example below a date is entered in A1, that date turns out to
be a saturday.
Now I want the macro to filter te collumn SAT.
25/04/09 SATURDAY
MON TUE WED THU FRI SAT SUN TEST
X X X X X X X Y
X X X X X X X Y
X X X X N
X X X X X N
X X X X X X X Y
X X X X X X X N
I hope someone can help me on this one
Regards,
M!ke
I'm looking for a way to filter data when a person enters a date in a
given cell.
Actually it doesn't need to be a cell, if it can be done with an
inputbox, that's fine.
In the example below a date is entered in A1, that date turns out to
be a saturday.
Now I want the macro to filter te collumn SAT.
25/04/09 SATURDAY
MON TUE WED THU FRI SAT SUN TEST
X X X X X X X Y
X X X X X X X Y
X X X X N
X X X X X N
X X X X X X X Y
X X X X X X X N
I hope someone can help me on this one
Regards,
M!ke