View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jai jai is offline
external usenet poster
 
Posts: 71
Default New Workbook from all sheet of a workbook

Hi,

I have workbook having 100s of sheet. I have to e-mail each sheet to
different individual. Is it any way to do this tedious work more simply
rather making different workbook one by one and then email those sheet one by
one.

Thanks & regards

Jai