Hi All,

I have a requirment for below

1) auto split file with setting filter by dept and by approv with sub
total; need to save as individual workbook
2) auto split file with setting filter for user with sut total and
need to save as indiviudal workbook
3) all individual file auto print out with landscape
4) send email with attach file for individual file to user and need to
cc to my intranet staff and bcc to my team head
5) print out the master file with sub total by approv too

orginal excel file look like:

Dept Approv User email address other data other data other data
Account A Ken (E-Mail Removed) x x x
Account A Man (E-Mail Removed) x x x
Account B Lilly (E-Mail Removed) x x x
Account B Lilly (E-Mail Removed) x x x
IT A Dave (E-Mail Removed) x x x


e.g. Approv A should be 2 individual file, look like:

file 1:

Dept Approv User email address other data other data other data
Account A Ken (E-Mail Removed) x x x
Account A Man (E-Mail Removed) x x x

file 2:

Dept Approv User email address other data other data other data
IT A Dave (E-Mail Removed) x x x


Please help!

Any one can help me..... please

See
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<(E-Mail Removed)> wrote in message news:e764f2f3-4ba2-483b-bd04-(E-Mail Removed)...
> Hi All,
>
> I have a requirment for below
>
> 1) auto split file with setting filter by dept and by approv with sub
> total; need to save as individual workbook
> 2) auto split file with setting filter for user with sut total and
> need to save as indiviudal workbook
> 3) all individual file auto print out with landscape
> 4) send email with attach file for individual file to user and need to
> cc to my intranet staff and bcc to my team head
> 5) print out the master file with sub total by approv too
>
> orginal excel file look like:
>
> Dept Approv User email address other data other data other data
> Account A Ken (E-Mail Removed) x x x
> Account A Man (E-Mail Removed) x x x
> Account B Lilly (E-Mail Removed) x x x
> Account B Lilly (E-Mail Removed) x x x
> IT A Dave (E-Mail Removed) x x x
>
>
> e.g. Approv A should be 2 individual file, look like:
>
> file 1:
>
> Dept Approv User email address other data other data other data
> Account A Ken (E-Mail Removed) x x x
> Account A Man (E-Mail Removed) x x x
>
> file 2:
>
> Dept Approv User email address other data other data other data
> IT A Dave (E-Mail Removed) x x x
>
>
> Please help!
>
>

Hii Ron,

Thanks your help on create autofilter and split unquie record macro,
but I still have problem on how to:

3) all individual file auto print out with landscape
4) send email with attach file for individual file to user and need
to
cc to my intranet staff and bcc to my team head
5) print out the master file with sub total by approv too

Please give me sugguestion. Thanks!

Maybe this new example on my site is better for you as a start
http://www.rondebruin.nl/mail/folder3/row2.htm

But maybe you not want a body mail ?





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<(E-Mail Removed)> wrote in message news:fc45737b-7943-4b2d-b8e1-(E-Mail Removed)...
> Hii Ron,
>
> Thanks your help on create autofilter and split unquie record macro,
> but I still have problem on how to:
>
> 3) all individual file auto print out with landscape
> 4) send email with attach file for individual file to user and need
> to
> cc to my intranet staff and bcc to my team head
> 5) print out the master file with sub total by approv too
>
> Please give me sugguestion. Thanks!
>
>
>