|
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 |
Date find and copy function.
You can do this with the Advanced filter with the copy to option with no code
or if you want to do it with code, you can use teh advanced filter in code. -- Regards, Tom Ogilvy "sungen99" wrote: 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 todays 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 thats 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 |
Date find and copy function.
No actually the trades will not be mixed up. They will be bunched -- sungen9 ----------------------------------------------------------------------- sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914 View this thread: http://www.excelforum.com/showthread.php?threadid=54432 |
Date find and copy function.
Tom how would you do that? i have never used that feature before -- sungen9 ----------------------------------------------------------------------- sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914 View this thread: http://www.excelforum.com/showthread.php?threadid=54432 |
Date find and copy function.
http://www.contextures.com/tiptech.html
Debra Dalgleish's site Read about the Advanced Filter. -- Regards, Tom Ogilvy "sungen99" wrote in message ... Tom how would you do that? i have never used that feature before. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=544324 |
Date find and copy function.
It would seem that the advance filter does not work for my application as I am getting an error saying that merged cells are not able to be looked up. Does anyone have the code for doing this with a macro. To answer the question from Don- no the dates will increase and will not be mixed up. Thanks so much for all your help in this. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=544324 |
Date find and copy function.
get rid of the merged cells
-- Don Guillett SalesAid Software "sungen99" wrote in message ... It would seem that the advance filter does not work for my application as I am getting an error saying that merged cells are not able to be looked up. Does anyone have the code for doing this with a macro. To answer the question from Don- no the dates will increase and will not be mixed up. Thanks so much for all your help in this. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=544324 |
| All times are GMT +1. The time now is 02:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com