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
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.
Rega
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 Underlayme
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 Ple
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. Thanks
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 ema
Dear Gaurav,
Pls share the file
regards,
Anil
On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani 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 individually instead of
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 mor
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 eve
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 a
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 ca
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
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
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
>
>
>
--
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
wrote:
> Thank you very much Mr.Paul, my solution is in you
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
wrote:
> From what I can see, you're looking
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
>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
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
can you share your chart type.
On Mon, Feb 2, 2015 at 5:49 PM, Sunil Kumar Yadav
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 want to know how i
:)
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.
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
Sunil appreciate your acceptance.
Cheers!!
On Mon, Feb 2, 2015 at 5:46 PM, Sunil Kumar Yadav
wrote:
> Ok Sorry next time i will keep in my mind.
>
> On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi wrote:
>
>> Dear Ashish Bhalara
>>
>> What exactly you are doing, can you pl explain..
>>
>> On Mon
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 +
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]
-
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
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
> > wrote:
>
>> Hi there i have twenty two plot
Ok Sorry next time i will keep in my mind.
On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi wrote:
> Dear Ashish Bhalara
>
> What exactly you are doing, can you pl explain..
>
> On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara
> wrote:
>
>> Dear experts,
>>
>> Below code is not work to check duplica
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
Dear Ashish Bhalara
What exactly you are doing, can you pl explain..
On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara
wrote:
> 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).Val
Dear Sunil
Please start new thread for your query.
Cheers!!
On Mon, Feb 2, 2015 at 4:57 PM, Sunil Kumar Yadav
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 please look
> below s
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
wrote:
> Hello Friends,
>
> i have checked many chart of Mr. Chando
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
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]
I have seen it ; look into code after going back home
On Feb 2, 2015 3:58 PM, "Vaibhav Joshi" wrote:
> Great, pl note i have replaced your code..
>
> On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul
> wrote:
>
>> Thanks Vaibhav it's working
>> On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote:
>>
>
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
Great, pl note i have replaced your code..
On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul
wrote:
> Thanks Vaibhav it's working
> On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote:
>
>> Hi Soumyendu..
>>
>> check this..
>>
>> Cheers!!
>>
>> On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul
>> wrote:
Thanks Vaibhav it's working
On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote:
> Hi Soumyendu..
>
> check this..
>
> Cheers!!
>
> On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul
> wrote:
>
>> Please help!!
>> On Feb 2, 2015 7:21 AM, "Soumyendu Paul" wrote:
>>
>>> I have already shared file please
Cheers!!
On Mon, Feb 2, 2015 at 2:48 PM, Nitin Balodi 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 12:59:48 +0530
>
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
Hi
Can you allocate partial plot to some one?
On Mon, Feb 2, 2015 at 4:09 AM, Salvation 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 group the allocat
41 matches
Mail list logo
