Could really use some help with this macro.

[sungen99]

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 al
the accounts I can copy the specific trader, click a button and up pop
that trades personal log. I paste the log and press another button tha
runs a nice macro to save the file, and send them an email along wit
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 maste
sheet and then have a macro that would take that days trades (based o
the date) and automatically copy them to the individual sheet, save i
and then send the email..

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

Thanks so very much in advance,
Ke

 

[Bob Phillips]

--

HTH

RP

 

[Bob Phillips]

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.