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 |
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 |
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 |
All times are GMT +1. The time now is 02:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com