Is this related the Copy Paste only particular to another sheet?
or is it a new question?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
No its new question. having trouble sending email to multiple recipients...
When I run my macro. It is sending email individually and pop up every time
when sending email. I want to send file to all mailer in just one go. like
To , Cc , Bcc. I hope I am explaining it correct.
On Mon, Feb 2, 2015
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
Hello Friends,
i have checked many chart of Mr. Chandoo...he used two or three range in
series value in one series in selected data source...i mean please look
below snapshot.
i want to know how i can select similiarly range in my data...i use window
2007.
Please!!!
[image: Inline image 1]
It's working Superb
Vaibhav Bhai you are Great!!!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Dear Sunil
Please start new thread for your query.
Cheers!!
On Mon, Feb 2, 2015 at 4:57 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com
wrote:
Hello Friends,
i have checked many chart of Mr. Chandoo...he used two or three range in
series value in one series in selected data source...i mean
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
hi Vabz.
No you cannot. it has to be the full plot
thanks in anticipation for a solution
On Monday, February 2, 2015 at 9:28:11 AM UTC+1, Vabz wrote:
Hi
Can you allocate partial plot to some one?
On Mon, Feb 2, 2015 at 4:09 AM, Salvation amph...@gmail.com javascript:
wrote:
Hi there i
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
I have to remove q = q + 1 to check every line.
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 6:17 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Thank you very much
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.
Thank you very much Mr.Paul, my solution is in your last line.
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 6:04 PM, Paul Schreiner schreiner_p...@att.net
wrote:
From what I
Dear experts,
Below code is not work to check duplicate value, please know me problem in
code.
For q = 5 To 1000
If Worksheets(BankData).Cells(q, 4).Value =
Worksheets(NewEntry).Cells(7, 2).Value Then
MsgBox Account number already exist, vbOKOnly, Ashish
Exit Sub
End If
q = q
Dear Ashish Bhalara
What exactly you are doing, can you pl explain..
On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
Below code is not work to check duplicate value, please know me problem in
code.
For q = 5 To 1000
If
Ok Sorry next time i will keep in my mind.
On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote:
Dear Ashish Bhalara
What exactly you are doing, can you pl explain..
On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
Below code is
Sunil appreciate your acceptance.
Cheers!!
On Mon, Feb 2, 2015 at 5:46 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com
wrote:
Ok Sorry next time i will keep in my mind.
On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote:
Dear Ashish Bhalara
What exactly you are doing, can you
Cheers!!
On Mon, Feb 2, 2015 at 2:48 PM, Nitin Balodi nitinbal...@live.com wrote:
Thanks Vaibhav, it worked. This group is really amazing. Thanks for your
support and help.
Thanks and Regards,
*Nitin Balodi*
--
From: v...@vabs.in
Date: Mon, 2 Feb 2015
I have seen it ; look into code after going back home
On Feb 2, 2015 3:58 PM, Vaibhav Joshi v...@vabs.in wrote:
Great, pl note i have replaced your code..
On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul soumyendu...@gmail.com
wrote:
Thanks Vaibhav it's working
On Feb 2, 2015 12:23 PM,
Please tell me what's wrong in code.
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 4:57 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com
wrote:
Hello Friends,
i have checked many
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
Hello Dears,
i have checked many chart of Mr. Chandoo...he used two or three range in
series value in one series in selected data source...i mean please look
below snapshot.
i want to know how i can select similiarly range in my data...i use window
2007.
Please!!!
[image: Inline image 1]
can you share your chart type.
On Mon, Feb 2, 2015 at 5:49 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com
wrote:
Hello Dears,
i have checked many chart of Mr. Chandoo...he used two or three range in
series value in one series in selected data source...i mean please look
below snapshot.
i
Thanks Vaibhav it's working
On Feb 2, 2015 12:23 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi Soumyendu..
check this..
Cheers!!
On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul soumyendu...@gmail.com
wrote:
Please help!!
On Feb 2, 2015 7:21 AM, Soumyendu Paul soumyendu...@gmail.com wrote:
Great, pl note i have replaced your code..
On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul soumyendu...@gmail.com
wrote:
Thanks Vaibhav it's working
On Feb 2, 2015 12:23 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi Soumyendu..
check this..
Cheers!!
On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu
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
:)
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
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
From what I can see, you're looking in rows 5 to 1000
and comparing the value in column (D) to the value in cell B7.
If you use the debugger to step through one line at a time and watch your value
for q,
you'll see that the loop:
For q = 5 to 1000
increments q by 1 for each iteration of the
Hi Gaurav,
Start new thread for new queries...!!
Regaeds
Ashish
On 3 February 2015 at 02:07, Gaurav Devrani
gauravdev1...@gmail.com wrote:
No its new question. having trouble sending email to multiple
recipients... When I run my macro. It is sending email individually and pop
up every
You really need to provide more information.
(it would be MOST helpful if you shared at least PART of the file)
There are MANY different email applications.
a simple list of email clients for Windows came up with 70.
so, which are you using?
what code are you using to get the 50 individual
I have also attached the file. in the attached file we are pulling our file
from specific location by browsing and then its sending emails to all . the
only concern is sending mail by clubing those emails in the single email. I
appreciate you being active on this group and being a good help.
Hi Gaurav,
PFA
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
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.(like; Cc, Bcc for 50
or
Dear Gaurav,
Pls share the file
regards,
Anil
On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani gauravdev1...@gmail.com wrote:
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
Dear All
Please help me for following problem
I used to get the data in 2 sheets Trial1 and Trial 2
I need to conoslidate this data in 3rd sheet results
It is very time consuming process.As I need to insert row after every row
of Trial 1 and copy paste from Trial 2 (there are more than 150 lines )
Try this code
http://www.excelvbamacros.in/2015/01/export-range-in-jason-format.html
On Monday, 5 August 2013 21:31:10 UTC+5:30, Godiva Man wrote:
Hi experts,
Does anyone have a VBA script to convert excel files that can define a
structure to be exported into a json format
--
Are
Dear friends
Can somebody help in recovering the attached file please.
Thanking you in anticipation of a quick reply
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
I'm pretty new at this and any help or direction is greatly appreciated.
So here's what I'm trying to do.
First you might wanna download my example file so you can follow along.
Looking at sheet 1 we have our first drop down; category in A4. I want to
select an option there (Either
Dear experts,
Please see attached file in which account no. field is text format but
copied in number format. Problem is that when I type 0123, data copied at
123 as per my coding, I also try by define variable as string but problem
same as standing.
Please edit my code to solve this issue.
Hi
Can you allocate partial plot to some one?
On Mon, Feb 2, 2015 at 4:09 AM, Salvation amphi...@gmail.com wrote:
Hi there i have twenty two plots of land and i want to allocate as much as
possible equal number of hectare of land to three land surveyors for
processing. the solution should
Thanks Vaibhav, it worked. This group is really amazing. Thanks for your
support and help.
Thanks and Regards,
Nitin Balodi
From: v...@vabs.in
Date: Mon, 2 Feb 2015 12:59:48 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
Hi
41 matches
Mail list logo