ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Seach Column and return multiple dates to another worksheet? (https://www.excelbanter.com/excel-worksheet-functions/6148-seach-column-return-multiple-dates-another-worksheet.html)

Mcasteel

Seach Column and return multiple dates to another worksheet?
 

I'm looking for a look-up solution for a worksheet.

My worksheet column 68 contains dates. I need to figure out how to
code the following scenario:

The end user enters a date into an input box:
dtReportDate = (Date:=strReportDate).

I want to display ALL matching dates in another worksheet("To Do List")
to create a report. Im assuming I will need some kind of a Loop
Statement or For Each statement.

Can anyone help me out?

Thanks.


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=277152



All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com