MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SEARCHing for an answer.


Posted by welshy31 on January 02, 2002 1:31 PM

I wonder if anyone can help. I am very new at excel code. I need to be able to "search" through about 20 cells and put all cells that match the current date into a list.

Please help. I have NO idea as of how to do this!

--welshy31


Posted by Tim on January 02, 2002 1:43 PM

Can you be more specific with a small example?

Posted by Tim on January 02, 2002 1:44 PM

Can you be more specific with a small example?

Posted by Scott on January 02, 2002 1:51 PM

You can use advanced filter for this. First, assuming that your dates are in Column A with the heading of "Date". Lets start the column in row 5. In A1, type in "Date", and in A2 type in today's date (or =today()). Now go to Data-Filter-Advanced Filter. Select "Copy to another location" In list range, highlight your date column including the header. In criteria highlight A1 and A2. In Copy to: put in the cell that you want the new list to go in. Make sure that Unique records only is unchecked, and click OK.