Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Paul Schreiner
, As long as ever you can.” - John Wesley - From: Gaurav Devrani gauravdev1...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, February 2, 2015 3:01 PM Subject: Re: $$Excel-Macros$$ Copy Paste only particular

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Gaurav Devrani
: $$Excel-Macros$$ Copy Paste only particular to another sheet Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Gaurav Devrani
Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time consuming. Is there anyway to get it fixed. Please. Hope I was clear

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Gaurav Devrani
And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: :) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Ashish Bhalara
Thank you very muc Mr.Vaibhav Mr.Gaurav Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: And Please check the filter again.

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Gaurav Devrani
Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear Vaibhavji, Thanks to

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Vaibhav Joshi
hi you can select cells which having formula giving errors by following steps: Press F5, then select special, now click radio button next to Formulas, uncheck all 3 except formulas. This will select only those cells having formula with error, now you can delete entire row by pressing Ctr + Sht

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Gaurav Devrani
:) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi v...@vabs.in wrote: Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Vaibhav Joshi
Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

2015-02-02 Thread Ashish Kumar
* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, February 2, 2015 3:01 PM *Subject:* Re: $$Excel-Macros$$ Copy Paste only particular to another sheet Can anyone help me on this? I have a specific data and want to send that data