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.

[Tom Ogilvy]

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

[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
[email protected]
"sungen99" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

--
Regards,
Tom Ogilvy

"sungen99" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

--
Don Guillett
SalesAid Software
[email protected]
"sungen99" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

--
Don Guillett
SalesAid Software
[email protected]
"sungen99" <[email protected]> wrote in
message news:[email protected]...
>
> 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.....
>
>
> --
> sungen99
> ------------------------------------------------------------------------
> sungen99's Profile:
> http://www.excelforum.com/member.php...fo&userid=9144
> View this thread: http://www.excelforum.com/showthread...hreadid=544324
>