Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
command in filter, then save as individual workbook and print out
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 x x x Account A Man x x x Account B Lilly x x x Account B Lilly x x x IT A Dave 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 x x x Account A Man x x x file 2: Dept Approv User email address other data other data other data IT A Dave x x x Please help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
command in filter, then save as individual workbook and print out
Any one can help me..... please
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
command in filter, then save as individual workbook and print out
See
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... 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 x x x Account A Man x x x Account B Lilly x x x Account B Lilly x x x IT A Dave 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 x x x Account A Man x x x file 2: Dept Approv User email address other data other data other data IT A Dave x x x Please help! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
command in filter, then save as individual workbook and print out
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
command in filter, then save as individual workbook and print out
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 wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an individual page in a workbook? | Excel Worksheet Functions | |||
Set print range for individual sheets (ranged) in workbook. | Excel Programming | |||
Save workbook via Command Button???? | Excel Programming | |||
Command Button to Save As Workbook... | Excel Programming | |||
save command bar into an excel workbook using vb | Excel Programming |