Hi All,
I am looking for HELP.
I have a excel table to store delivery job. we put Location, trucking number, delivery and service..etc in the sheet called (delivery)
and it is required to copy some cells to sheet called (report) when it is match certain criteria on the sheet (delivery)
example:
if (delivery) A2 = HongKong and delivery date in C2 within 1 jan to 15 Jan . when the criterias matched it should copy to sheet (report). i try below formular but it is wrong.
=IFERROR(INDEX(delivery!A$2:A$10,SMALL(IF(AND(delivery!A$2:A$10=$F$2,AND(delivery!$C3>=report!$D$2,delivery!$C3<=report!$E$2)),ROW(delivery!A$2:A$10)-1),ROW(delivery!A2))),"")
F2=Location. e.g HongKong, Kowloon, NT D2= date_open E2=date_close
attached two files:
the TT-tracker-1 is the practice file but fail
the second file MI tracker -2 is what i attended to achieve. But I don’’t how to copy data and automatically sort out the blank row as like this file. Is there anyone know?
Thank you in advance.
Bookmarks