how do I automate emailing filtered data

  • Thread starter Thread starter Jenny Smit
  • Start date Start date
J

Jenny Smit

Bearing in mind I have no clue about VBA or Macros, could someone end my
agony. I have a large data set and need filter data by a single column
(owner) and then magically email to each "owner" their particular data. I
have filtered the data, so no problem with that. But how do I get the
particular owners data to him, without sending any of the other data too. I
need to automate this entire process as I will have to do this quarterly.

Thank you so much
 
ctrl+G
press Special
Visible cells only
copy
paste as values to another workbook
File->Send to

HIH
 
Jenny,

There is one more way to do this.
Say for eg. Select the cells having owners data
then ctrl+C, Ctrl+N,Ctrl+V
then save the file with the owners name, once the file is saved in the
owners name you can open the file and click File/Send/As email Attachement.

Please let me know your feedback
 
Back
Top