Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to copy table from one sheet to anothe
Hi
I need to copy specific table from one shhe to anothe and send the target shhet by e-mail. the catch is that I need o do all that only if there is any details in specific column - c at any row. so basicly I need 2 procedure one to chec if there is any value in c column, and if that true to copy the table and send the sheet to my manager. I've tried some code but it not work properly. If anyone has something to offer, Thanks |
#2
|
|||
|
|||
Hi Maya
See http://www.rondebruin.nl/sendmail.htm For the check use the change event See the example on this page http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Maya" wrote in message ... Hi I need to copy specific table from one shhe to anothe and send the target shhet by e-mail. the catch is that I need o do all that only if there is any details in specific column - c at any row. so basicly I need 2 procedure one to chec if there is any value in c column, and if that true to copy the table and send the sheet to my manager. I've tried some code but it not work properly. If anyone has something to offer, Thanks |
#3
|
|||
|
|||
Thanks. "Ron de Bruin" wrote in message ... Hi Maya See http://www.rondebruin.nl/sendmail.htm For the check use the change event See the example on this page http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Maya" wrote in message ... Hi I need to copy specific table from one shhe to anothe and send the target shhet by e-mail. the catch is that I need o do all that only if there is any details in specific column - c at any row. so basicly I need 2 procedure one to chec if there is any value in c column, and if that true to copy the table and send the sheet to my manager. I've tried some code but it not work properly. If anyone has something to offer, Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Copy formula...sheet 2 sheet | New Users to Excel | |||
copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |