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

2015-02-02 Thread Ashish Kumar
u >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John Wesley* >> ----- >> >> *From:* Gaurav Devrani >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, Februar

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

2015-02-02 Thread Gaurav Devrani
ent:* 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 to multiple recipients (have around 50 emails) but when i run my > macro.

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

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

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 en

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 wrote: > And Please check the filter again. I guess I dint put th

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 wrote: > :) > > On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi wrote: > >> G

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 wrote: > Great Tip by Gaurav.. > > On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani > 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.

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 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 Mon, Feb 2, 20

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
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 wrote: > Dear Vaibhavji, > > Thanks to reply, my query to chec

$$Excel-Macros$$ Copy & Paste only particular to another sheet

2015-02-02 Thread Ashish Bhalara
Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy & paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara 96