Good morning all
i have to validated data based on Month selected in Column A of a sheet "DATA" in Column B and conditional range is on Sheet List so, if A1 is January B1 should display only dates belongs to January if its March than Dates only for March and so on i did validate this upto July but after 7 conditions in IF it's not working.
May i request for your help to fix it or advise an alternative way.
thanks for your kind help.
B Regards
i have to validated data based on Month selected in Column A of a sheet "DATA" in Column B and conditional range is on Sheet List so, if A1 is January B1 should display only dates belongs to January if its March than Dates only for March and so on i did validate this upto July but after 7 conditions in IF it's not working.
May i request for your help to fix it or advise an alternative way.
thanks for your kind help.
B Regards