macro
 

Hi, i have an database, in sheet (PLANNING), like this:

alex (a) monday
maria b friday
felix (f) tuesday
cat friday
etc...

In the same workbook i have 6 more sheets : (monday, tuesday,
wednesday,thursday, friday, and SEARCH)

I need the macro to know what day it's today, (ex: friday); than...to
compare the database from "PLANNING" sheet (ex: cat (c) friday, etc...)
with names in all sheets except "PLANNING" and SEARCH"; i need in a sheet
"REST" to display only the names that doesn't appear in "friday" sheet, and
to display something like that (ex: alex (A) monday) if the macro find the
name in other day(sheet) . In every day of the week to do the same. (Monday
to search in PLANNINGS for monday names and the one that matches,
tuesday.....the same...etc.)


Thanks in advance