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

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

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