dear All
i have in my attached file in report sheet the following
i have three cases in J2
if i select one case like in my example Product & Load they will goto direct to see match data from ref sheet
and according to date in D2 in report sheet it see match value from sheet ref according to day
if they found Y its meaning copy corresponding value from Column C (ref) to Column A in report sheet
in my attached file you can find AA9 not copied because the date in D2 is Sunday and according to
ref Sunday for AA9 is N
hope you can understand me
Bookmarks