Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pheraps i need a macro...
I have a sheet with data and I want to automatically create a sheet by code
(column C) with the referring data. Later each sheet will have to be sent for the respective email. Exists some way of making? How? Example: Code Descrição Quantidade Nome 75 Y 10 Sandra 75 Y 10 António 76 Y 12 Sandra 77 Y 8 Xana Best Regards Sandra Bárbara |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pheraps i need a macro...
No short answer, as what you are asking about would require many details from
your application......but for starters, I would advise you look in to the AutoFilter feature........this will filter out all your data by CODE so you can then copy and paste it to separate sheets to email......... hth Vaya con Dios, Chuck, CABGx3 "SBárbara" wrote: I have a sheet with data and I want to automatically create a sheet by code (column C) with the referring data. Later each sheet will have to be sent for the respective email. Exists some way of making? How? Example: Code Descrição Quantidade Nome 75 Y 10 Sandra 75 Y 10 António 76 Y 12 Sandra 77 Y 8 Xana Best Regards Sandra Bárbara |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pheraps i need a macro...
Thanks for your answer, but i have innumerable codes. I need something to
automatically generate sheets corresponding to each code and to send each one to the respective email. Best regards, Sandra Bárbara "CLR" escreveu: No short answer, as what you are asking about would require many details from your application......but for starters, I would advise you look in to the AutoFilter feature........this will filter out all your data by CODE so you can then copy and paste it to separate sheets to email......... hth Vaya con Dios, Chuck, CABGx3 "SBárbara" wrote: I have a sheet with data and I want to automatically create a sheet by code (column C) with the referring data. Later each sheet will have to be sent for the respective email. Exists some way of making? How? Example: Code Descrição Quantidade Nome 75 Y 10 Sandra 75 Y 10 António 76 Y 12 Sandra 77 Y 8 Xana Best Regards Sandra Bárbara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |