Date find and copy function.

[sungen99]

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.

 

[Guest]

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.

 

[Don Guillett]

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
(e-mail address removed)

 

[sungen99]

No actually the trades will not be mixed up. They will be bunched

 

[sungen99]

Tom how would you do that? i have never used that feature before

 

[Tom Ogilvy]

http://www.contextures.com/tiptech.html
Debra Dalgleish's site
Read about the Advanced Filter.

 

[sungen99]

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.

 

[Don Guillett]

get rid of the merged cells

 

[sungen99]

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.....

 

[Don Guillett]

Send me the file along with complete instructions and reference to this
discussion and I will take a look