I have a worksheet (Worksheet1) with Cols A thru U on line 1.....Col K
is a due date......data is present from Line 2 thru umpteen
rows....Worksheet2 will be a summary sheet for data entered on
Worksheet1, with identical columns but column headings are on line 2
instead of line 1, F1 has a start date. I would like to search
Worksheet1 Col K for a match to the start date entered into Worksheet2
F1 and copy the matched lines to Worksheet2, provided Cols P and R on
Worksheet1 are blank. I basically want to set up Worksheet2 to have a
weekly readout of things that will be due that week, broken down into
days. I can set up the worksheet alright, but the search and the
copying are ten miles above my head.....any help, or a nudge in the
right directions will be very much appreciated. Much thanks in
advance!!
Ken