Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 1 February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
using a cell value to control a counter inside a macro and displaying macro value ocset Excel Worksheet Functions 1 September 10th 06 05:32 AM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 1 June 11th 05 12:44 AM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 0 June 10th 05 03:38 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"