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

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

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

"sungen99" wrote in
message ...

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

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

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

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

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