Ken,

Record a macro that filters the date column with a value of today's date,
copy the visible rows to a new workbook, and save the new workbook. Then
mail the saved workbook. You should have enough code to work with then.

--

HTH

RP

"sungen99" wrote in message
...

What I have been able to do so far with your help:
I have been able to create a nice macro so from the master list of all
the accounts I can copy the specific trader, click a button and up pops
that trades personal log. I paste the log and press another button that
runs a nice macro to save the file, and send them an email along with
the attachment of that days trades. It's very fancy and I love it!

What I would Like to be able to do:
I would like to be able to enter the orders for the day on the master
sheet and then have a macro that would take that days trades (based on
the date) and automatically copy them to the individual sheet, save it
and then send the email..

How much am I asking for? is this very complex? am I giving all the
info you need to suggest something?

Thanks so very much in advance,
Ken


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=268553