| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date find and copy function.
I have a list of trades that I keep track of. The file just keeps getting longer and longer. At the end of the day I would like to click a macro that looks at Sheet1 and checks to see if the date (in column B) is today’s date. If it is copy that line to Sheet2 and continue to check until the end of the list of trades on Sheet1. I can do a macro that uses sort but that’s not really efficient. Any help you can give as always is very much appreciated. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=544324 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I find the copy down function | Excel Worksheet Functions | |||
| how do I find the copy down function | Excel Worksheet Functions | |||
| function to find and copy data | Excel Worksheet Functions | |||
| find date and copy selection | Excel Programming | |||
| Find date and copy range based on that date | Excel Programming | |||
![sungen99[_109_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
