Formula questions

[Ken]

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

 

[Ken]

Hi Group,
No answers so far, but here is what I've attempted (but doesn't
work!)....please believe me, I have been trying for days on this
one....the basic thought is there, but I'm not getting anywhere with
it....would VBE (which I can't write) be a better solution?? If it is,
then I'm done! Thanks for any guidance!

=IF((Sheet1!K:K=$F$1)*AND(Sheet1!R:R="",Sheet1!P=""),MyRange,"")

Ken

 

[Spiky]

Hi Group,
No answers so far, but here is what I've attempted (but doesn't
work!)....please believe me, I have been trying for days on this
one....the basic thought is there, but I'm not getting anywhere with
it....would VBE (which I can't write) be a better solution?? If it is,
then I'm done! Thanks for any guidance!

=IF((Sheet1!K:K=$F$1)*AND(Sheet1!R:R="",Sheet1!P=""),MyRange,"")

Ken

Which data (meaning which columns) are you trying to transfer from one
sheet to the other? Sounds like you already have some data typed into
Worksheet2 and don't need to transfer all 20 columns.

Also, is each line unique so that there is only one possible match for
each line you want to transfer?

 

[Ken]

Which data (meaning which columns) are you trying to transfer from one
sheet to the other? Sounds like you already have some data typed into
Worksheet2 and don't need to transfer all 20 columns.

Also, is each line unique so that there is only one possible match for
each line you want to transfer?

Spiky,
Cols A thru M are the ones to transfer to Sheet2....there may be
several matches based on the date entered in Sheet 2 F1....if I wanted
to find which items are due on 6/23/08, then transfer all lines (Cols
A thru M) with the due date of 6/23/08 in Col K (Due Date column)to
Sheet2, providing Cols P and R are blank...the due date is entered in
Sheet2 F1.....I know it's a bit complicated to explain, but I will
have Sheet 2 divided into sections for the date in F1(Mon), a section
for F1+1(Tue), for F1+2(Wed), F1+3(Thu), and F1 +4(Fri)....I know that
I can use the filtering process, and then copy/paste etc to achieve
this, just wanted to do it just a little bit better....it's looking
more and more like VB is probably the best way to do it....thank you
for reading my post!
Ken