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

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

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