 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2006Date 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.  Signaturesungen99 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. SignatureRegards, Tom Ogilvy > 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 [quoted text clipped - 4 lines] > 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. Are you saying that the trade dates will be mixed up 5/1 5/2 5/1 5/3 5/1 Don Guillett SalesAid Software dguillett1@austin.rr.com > 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 [quoted text clipped - 4 lines] > 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. No actually the trades will not be mixed up. They will be bunched Tom how would you do that? i have never used that feature before http://www.contextures.com/tiptech.html Debra Dalgleish's site Read about the Advanced Filter. SignatureRegards, Tom Ogilvy > Tom how would you do that? i have never used that feature before. 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. Signaturesungen99 get rid of the merged cells SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > > It would seem that the advance filter does not work for my application [quoted text clipped - 6 lines] > > Thanks so much for all your help in this. That would be the best thing to do but with over 5000 lines. The merging of the data would be a mess. I unfortunately need to do this with a macro. I am actually getting desperate for the solution so if someone is interested and has paypal..... Signaturesungen99 Send me the file along with complete instructions and reference to this discussion and I will take a look SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > > That would be the best thing to do but with over 5000 lines. The merging > of the data would be a mess. I unfortunately need to do this with a > macro. I am actually getting desperate for the solution so if someone > is interested and has paypal..... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.