Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula questions
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula questions
On Jun 18, 4:37 pm, Ken wrote:
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: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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula questions
On Jun 19, 10:28*am, Spiky wrote:
On Jun 18, 4:37 pm, Ken wrote: 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: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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Questions with a formula.. | Excel Worksheet Functions | |||
Formula Questions... | Excel Worksheet Functions | |||
Formula questions | Excel Worksheet Functions | |||
Formula questions | Excel Discussion (Misc queries) | |||
Formula Help 2 QUESTIONS | Excel Discussion (Misc queries) |