Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Could really use some help with this macro.
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 -- sungen9 ----------------------------------------------------------------------- sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914 View this thread: http://www.excelforum.com/showthread.php?threadid=26855 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Could really use some help with this macro.
-- 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Could really use some help with this macro.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |