$$Excel-Macros$$ Urgent required Perl Developer - (REMOTE POSITION)

[Gary .]

*Please respond to gurjant.si...@damcosoft.com
*




*Position: Perl DeveloperLocation: Remote, anywhere in USADuration: 6
months, possibility of extension*
Requirements/Skills:

•Total Experience: 6-8+ years
•Perl/shell programming
•System level skill
•Good old OO programming

Thanks and Regards,



Gurjant Singh - (Gary)

Technical Recruiter

+1 212 389 9503 ext 208

E: gurjant.si...@damcosoft.com



*NY Office:  *112 W 34th St, 18th Floor, New York, NY 10120

*NJ Office:  *894 Green Street, Suite B, Iselin, NJ 08830



Corporate: www.damcosoft.com

*[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]*



*[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]*



*P** Please consider the planet before printing | Switch off as you go
|**q**Recycle
always |* *Your child deserves a better world*

*CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message*

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: run-time error '1004': Reference is not valid.

['deanalt' via MS EXCEL AND VBA MACROS]

Thank you very much, Paul.  When I received the file, it was quickly 
obvious that this other party had introduced an error into the file that 
was producing a bunch of #0's and such and that the goal seek would never 
be able to find a solution.  I guess these VBA error messages are just too 
generic for my tastes.   It seemed more like the kind of messge you get 
when something isn't dimensioned properly, etc.  I expected something a lot 
more subtle!  Next time I will know to ask for the file first, before I go 
jumping to conclusions.

Thanks again for your very thoughtful answer.

Dean

On Friday, July 18, 2014 6:18:06 PM UTC-7, deanalt wrote:
>
> I sent someone an EXCEL macro enabled workbook file (created in EXCEL 
> 2010) and they ran some macros, saved the result, then later tried to run a 
> different macro and got the error message in the subject line.   I had no 
> such problem in running it just the way they did it on my computer.  It is 
> possible they have an older or newer version of EXCEL than I do, i.e., not 
> 2010.  Below is the very short macro.  Is there anything here that lends 
> itself to not working on a different version of EXCEL?
>
> Even if there is no clue, is there a way to change the macro, maybe by 
> declaring something or whatever, to ensure it will probably run on other 
> computers better?
>
> I created this macro a long time ago, am a novice at macros, and don't 
> recall if I recorded all of this macro or just some of it, then edited it.  
> But it works for me just fine.
>
> Thanks so much!
> Dean
>
> Sub ComputeInterestRates()
> Application.MaxChange = 0.01
> Application.Goto Reference:="GoalSeekPERSIR"
> Range("GoalSeekPERSIR").GoalSeek Goal:=0, 
> ChangingCell:=Range("CalPERSImpliedInterestRate")
> Application.Goto Reference:="GoalSeekIndexIR"
> Range("GoalSeekIndexIR").GoalSeek Goal:=0, 
> ChangingCell:=Range("BenchmarkImpliedInterestRate")
> Application.Goto Reference:="R16C1"
> End Sub
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Merge Word Documents through EXCEL VBA

[MCN]

Hey Paul.

I want to append all word documents to the first word document (which is 
always a "Cover" for the report).

best,

On Monday, July 21, 2014 2:28:47 PM UTC-3, Paul Schreiner wrote:
>
> Are you saying you want to copy the CONTENT of the Word Documents to an 
> Excel workbook? or append each of the Word Documents to a new Word 
> document? 
>  
> *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,As long as ever you can.” - John Wesley*
> -
>
>*From:* MCN >
> *To:* excel-...@googlegroups.com  
> *Sent:* Monday, July 21, 2014 12:39 PM
> *Subject:* $$Excel-Macros$$ Merge Word Documents through EXCEL VBA
>  
> I'm creating an internal report for a company, which can be composed of up 
> to 8 separate sections (8 independent documents). Depending on the client, 
> I want it to use sections X, Y, Z, etc. Each section is already in a 
> separate word document (a basic template). 
>
> I have managed to correctly create a macro that copies the specific 
> sections (separate documents) I want to a separate folder, and now I want 
> to add a macro that all those documents into a new one, then saves it with 
> a specific name, and creates a pdf.
>
> The file names and paths are all listed in the spreadsheet already...
>
> Any suggestions?
>
> best,
> -- 
> 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 Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>  

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Merge Word Documents through EXCEL VBA

[Paul Schreiner]

Are you saying you want to copy the CONTENT of the Word Documents to an Excel 
workbook? or append each of the Word Documents to a new Word document? 

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,
As long as ever you can.” - John Wesley
-


>
> From: MCN 
>To: excel-macros@googlegroups.com 
>Sent: Monday, July 21, 2014 12:39 PM
>Subject: $$Excel-Macros$$ Merge Word Documents through EXCEL VBA
>  
>
>
>I'm creating an internal report for a company, which can be composed of up to 
>8 separate sections (8 independent documents). Depending on the client, I want 
>it to use sections X, Y, Z, etc. Each section is already in a separate word 
>document (a basic template). 
>
>I have managed to correctly create a macro that copies the specific sections 
>(separate documents) I want to a separate folder, and now I want to add a 
>macro that all those documents into a new one, then saves it with a specific 
>name, and creates a pdf.
>
>The file names and paths are all listed in the spreadsheet already...
>
>Any suggestions?
>
>
>
>best,
-- 
>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 Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Merge Word Documents through EXCEL VBA

[MCN]

I'm creating an internal report for a company, which can be composed of up 
to 8 separate sections (8 independent documents). Depending on the client, 
I want it to use sections X, Y, Z, etc. Each section is already in a 
separate word document (a basic template). 

I have managed to correctly create a macro that copies the specific 
sections (separate documents) I want to a separate folder, and now I want 
to add a macro that all those documents into a new one, then saves it with 
a specific name, and creates a pdf.

The file names and paths are all listed in the spreadsheet already...

Any suggestions?

best,

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

[Ashish Kumar]

Hi Vaibhav Ji,

This sheet is Working better than the first one.

Tremendous..!!!


Regards
Ashish


On 21 July 2014 20:03, Vaibhav Joshi  wrote:

> Hi
>
> Check this, i have added Ok button in First form, only after pressing Ok
> now form 2 will appear & also added check box in front of cc button to keep
> & remove cc.
>
> Thanks
>
>
> On Mon, Jul 21, 2014 at 5:45 PM, Ashu k  wrote:
>
>> Dear Vaibhav Sir,
>>
>> Code is working great. But, I am facing 2 problems with that.
>>
>> First is -   that's not working when i don't place email id in CC. If
>> i don't want to send carbon copy to someone than what to do.
>>
>> Second is - when i select the city name from the drop box, it will
>> capture and send all the data.
>>
>> Ex. - If i select chennai than only capture the chennai data in excel
>> sheet and send it.
>>
>> please help in this regards.
>>
>> Thanks
>> Ashu Kenith
>>
>>
>> > -- Forwarded message --
>> > From: Vaibhav Joshi 
>> > Date: 19 July 2014 22:02
>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
>> > To: "excel-macros@googlegroups.com" 
>> >
>> >
>> > Check this..
>> >
>> > Cheers!!
>> >
>> >
>> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay 
>> wrote:
>> >
>> >> Dear Team,
>> >>
>> >>
>> >> Please Help on this to Solve this Problem !!!
>> >>
>> >>
>> >> Regards,
>> >>
>> >> Vijayakumar R
>> >>
>> >> On Monday, July 14, 2014 3:46:45 PM UTC+5:30, Vijay wrote:
>> >>
>> >>> Dear Team,
>> >>>
>> >>> need your help to solve this problem !!!
>> >>>
>> >>>
>> >>> 1) PFA, attached File already done by this Team, but require some more
>> >>> query to be rectify
>> >>>
>> >>>
>> >>> 2) This file Start Button having in ( Br ) Column, require once press
>> >>> the
>> >>> start button, branch name based File should
>> >>>
>> >>> be Split only the same Branch like ( If i select Chennai means splited
>> >>> file branch name should be available only
>> >>>
>> >>> Chennai branch pertains to data ) and file also attached based on the
>> >>> Branch name pertains to Branch Email ID.
>> >>>
>> >>> 3) No need the start button to press the file, Run through only in
>> Macro
>> >>> and Splited file this start button wont
>> >>>
>> >>> appear.
>> >>>
>> >>>  Thanks in Advance.
>> >>>
>> >>> Regard,
>> >>>
>> >>> Vijay
>> >>>
>> >>>
>> >>>
>> >>  --
>> >> 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 Please
>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> >> will not get quick attention or may not be answered.
>> >> 2) Don't post a question in the thread of another member.
>> >> 3) Don't post questions regarding breaking or bypassing any security
>> >> measure.
>> >> 4) Acknowledge the responses you receive, good or bad.
>> >> 5) Jobs posting is not allowed.
>> >> 6) Sharing copyrighted material and their links is not allowed.
>> >>
>> >> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and
>> >> members are not responsible for any loss.
>> >> ---
>> >> You received this message because you are subscribed to the Google
>> Groups
>> >> "MS EXCEL AND VBA MACROS" group.
>> >> To unsubscribe from this group and stop receiving emails from it, send
>> an
>> >> email to excel-macros+unsubscr...@googlegroups.com.
>> >> To post to this group, send email to excel-macros@googlegroups.com.
>> >> Visit this group at http://groups.google.com/group/excel-macros.
>> >> For more options, visit https://groups.google.com/d/optout.
>> >>
>> >
>> >  --
>> > 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 Please
>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> > will not get quick attention or may not be answered.
>> > 2) Don't post a question in the thread of another member.
>> > 3) Don't post questions regarding breaking or bypassing any security
>> > measure.
>> > 4) Acknowledge the responses you receive, good or bad.
>> > 5) Jobs posting is not allowed.
>> > 6) Sharing copyrighted material and their links is not allowed.
>> >
>> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> > members are not responsible for any loss.
>> > ---
>> > You received this message because you are subscribed to the Google
>> Groups
>> > "MS EXCEL AND VBA MACROS" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> an
>> > email to excel-macros+unsubscr...@googlegroups.com.
>> > To post to this group, send email to excel-macros@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/excel

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

[Ashu k]

Dear Vaibhav Sir,

Working Fine.

Thanks
Ashu Kenith

On 7/21/14, Vaibhav Joshi  wrote:
> Hi
>
> Check this, i have added Ok button in First form, only after pressing Ok
> now form 2 will appear & also added check box in front of cc button to keep
> & remove cc.
>
> Thanks
>
>
> On Mon, Jul 21, 2014 at 5:45 PM, Ashu k  wrote:
>
>> Dear Vaibhav Sir,
>>
>> Code is working great. But, I am facing 2 problems with that.
>>
>> First is -   that's not working when i don't place email id in CC. If
>> i don't want to send carbon copy to someone than what to do.
>>
>> Second is - when i select the city name from the drop box, it will
>> capture and send all the data.
>>
>> Ex. - If i select chennai than only capture the chennai data in excel
>> sheet and send it.
>>
>> please help in this regards.
>>
>> Thanks
>> Ashu Kenith
>>
>>
>> > -- Forwarded message --
>> > From: Vaibhav Joshi 
>> > Date: 19 July 2014 22:02
>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
>> > To: "excel-macros@googlegroups.com" 
>> >
>> >
>> > Check this..
>> >
>> > Cheers!!
>> >
>> >
>> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay 
>> > wrote:
>> >
>> >> Dear Team,
>> >>
>> >>
>> >> Please Help on this to Solve this Problem !!!
>> >>
>> >>
>> >> Regards,
>> >>
>> >> Vijayakumar R
>> >>
>> >> On Monday, July 14, 2014 3:46:45 PM UTC+5:30, Vijay wrote:
>> >>
>> >>> Dear Team,
>> >>>
>> >>> need your help to solve this problem !!!
>> >>>
>> >>>
>> >>> 1) PFA, attached File already done by this Team, but require some
>> >>> more
>> >>> query to be rectify
>> >>>
>> >>>
>> >>> 2) This file Start Button having in ( Br ) Column, require once press
>> >>> the
>> >>> start button, branch name based File should
>> >>>
>> >>> be Split only the same Branch like ( If i select Chennai means
>> >>> splited
>> >>> file branch name should be available only
>> >>>
>> >>> Chennai branch pertains to data ) and file also attached based on the
>> >>> Branch name pertains to Branch Email ID.
>> >>>
>> >>> 3) No need the start button to press the file, Run through only in
>> Macro
>> >>> and Splited file this start button wont
>> >>>
>> >>> appear.
>> >>>
>> >>>  Thanks in Advance.
>> >>>
>> >>> Regard,
>> >>>
>> >>> Vijay
>> >>>
>> >>>
>> >>>
>> >>  --
>> >> 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
>> >> Please
>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> >> Advice
>> >> will not get quick attention or may not be answered.
>> >> 2) Don't post a question in the thread of another member.
>> >> 3) Don't post questions regarding breaking or bypassing any security
>> >> measure.
>> >> 4) Acknowledge the responses you receive, good or bad.
>> >> 5) Jobs posting is not allowed.
>> >> 6) Sharing copyrighted material and their links is not allowed.
>> >>
>> >> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> >> and
>> >> members are not responsible for any loss.
>> >> ---
>> >> You received this message because you are subscribed to the Google
>> Groups
>> >> "MS EXCEL AND VBA MACROS" group.
>> >> To unsubscribe from this group and stop receiving emails from it, send
>> an
>> >> email to excel-macros+unsubscr...@googlegroups.com.
>> >> To post to this group, send email to excel-macros@googlegroups.com.
>> >> Visit this group at http://groups.google.com/group/excel-macros.
>> >> For more options, visit https://groups.google.com/d/optout.
>> >>
>> >
>> >  --
>> > 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 Please
>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> > will not get quick attention or may not be answered.
>> > 2) Don't post a question in the thread of another member.
>> > 3) Don't post questions regarding breaking or bypassing any security
>> > measure.
>> > 4) Acknowledge the responses you receive, good or bad.
>> > 5) Jobs posting is not allowed.
>> > 6) Sharing copyrighted material and their links is not allowed.
>> >
>> > NOTE : Don't ever post confidential data in a workbook. Forum owners
>> > and
>> > members are not responsible for any loss.
>> > ---
>> > You received this message because you are subscribed to the Google
>> > Groups
>> > "MS EXCEL AND VBA MACROS" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> > an
>> > email to excel-macros+unsubscr...@googlegroups.com.
>> > To post to this group, send email to excel-macros@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/excel-macros.
>> > For mor

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

[Paul Schreiner]

Oops, yes you included the range in the indirect() string.
 
so, the solution was simply using the text() function to convert the date 
number to a string 

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,
As long as ever you can.” - John Wesley
-


>
> From: Paul Schreiner 
>To: "excel-macros@googlegroups.com"  
>Sent: Monday, July 21, 2014 8:42 AM
>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please 
>Help
>  
>
>
>By way of explanation:
>
>The Dates you have in column "A" are actually numbers.
>(the number of days since 1/1/1900)
>
>The sheet names are strings (of course)
>
>So, from looking at your sheet names, 7/1/2014 is actually:
>7-Jan-2014, which, to Excel is: 41646
>
>To convert this number to a string that resembles your sheet names, I used:
>TEXT($A5,"dd-mm-")
>
>Then used (nearly) what you did originally with the indirect() function.
>but, I believe you did not include the Range (C18:C40) within the indirect 
>string definition.
>Which you need to do.
>
>hope it helps.
>
>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,
>As long as ever you can.” - John Wesley
>-
>
>
> From: Paul Schreiner 
>>To: "excel-macros@googlegroups.com"  
>>Sent: Monday, July 21, 2014 8:35 AM
>>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please 
>>Help
>>  
>>
>>
>> For your sumif(Indirect function in cell B5, try:
>>
>>=SUMIF(INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!C18:C40"),B$3,INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!F18:F40"))
>> (It should copy to D, F, H, J also)
>>
>>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,
>>As long as ever you can.” - John Wesley
>>-
>>
>>
>> From: Dileep Kumar 
>>>To: excel-macros@googlegroups.com 
>>>Cc: Haseeb Avarakkan  
>>>Sent: Monday, July 21, 2014 7:42 AM
>>>Subject: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help
>>>  
>>>
>>>
>>>Dear Friends,
>>>
>>>
>>>Please find attached Daily Reporting Formate of Excel in the summary sheet I 
>>>am unable to get the vales using indirect function.
>>>
>>>
>>>Please help me friends.
>>>
>>>
>>>-- 
>>>
>>>Regards,
>>>Dileep Kumar Kaza
>>> 
-- 
>>>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 Please 
>>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
>>>not get quick attention or may not be answered.
>>>2) Don't post a question in the thread of another member.
>>>3) Don't post questions regarding breaking or bypassing any security measure.
>>>4) Acknowledge the responses you receive, good or bad.
>>>5) Jobs posting is not allowed.
>>>6) Sharing copyrighted material and their links is not allowed.
>>> 
>>>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>>>members are not responsible for any loss.
>>>--- 
>>>You received this message because you are subscribed to the Google Groups 
>>>"MS EXCEL AND VBA MACROS" group.
>>>To unsubscribe from this group and stop receiving emails from it, send an 
>>>email to excel-macros+unsubscr...@googlegroups.com.
>>>To post to this group, send email to excel-macros@googlegroups.com.
>>>Visit this group at http://groups.google.com/group/excel-macros.
>>>For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>>
>>-- 
>>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 Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>>2) Don't post a question in the thread of another member.
>>3) Don't post questions regarding breaking or bypassing any security measure.
>>4) Acknowledge the responses you receive, good or bad.
>>5) Jobs posting is not allowed.
>>6) Sharing copyrighted material and their links is not allowed.
>> 
>>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>>members are not responsible for any loss.
>>--- 
>>You received this message because you are subscribed to the Google

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

[Paul Schreiner]

By way of explanation:
 
The Dates you have in column "A" are actually numbers.
(the number of days since 1/1/1900)
 
The sheet names are strings (of course)
 
So, from looking at your sheet names, 7/1/2014 is actually:
7-Jan-2014, which, to Excel is: 41646
 
To convert this number to a string that resembles your sheet names, I used:
TEXT($A5,"dd-mm-")
 
Then used (nearly) what you did originally with the indirect() function.
but, I believe you did not include the Range (C18:C40) within the indirect 
string definition.
Which you need to do.
 
hope it helps.

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,
As long as ever you can.” - John Wesley
-

 From: Paul Schreiner 
>To: "excel-macros@googlegroups.com"  
>Sent: Monday, July 21, 2014 8:35 AM
>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please 
>Help
>  
>
>
> For your sumif(Indirect function in cell B5, try:
>
>=SUMIF(INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!C18:C40"),B$3,INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!F18:F40"))
> (It should copy to D, F, H, J also)
>
>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,
>As long as ever you can.” - John Wesley
>-
>
>
> From: Dileep Kumar 
>>To: excel-macros@googlegroups.com 
>>Cc: Haseeb Avarakkan  
>>Sent: Monday, July 21, 2014 7:42 AM
>>Subject: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help
>>  
>>
>>
>>Dear Friends,
>>
>>
>>Please find attached Daily Reporting Formate of Excel in the summary sheet I 
>>am unable to get the vales using indirect function.
>>
>>
>>Please help me friends.
>>
>>
>>-- 
>>
>>Regards,
>>Dileep Kumar Kaza
>> 
-- 
>>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 Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>>2) Don't post a question in the thread of another member.
>>3) Don't post questions regarding breaking or bypassing any security measure.
>>4) Acknowledge the responses you receive, good or bad.
>>5) Jobs posting is not allowed.
>>6) Sharing copyrighted material and their links is not allowed.
>> 
>>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>>members are not responsible for any loss.
>>--- 
>>You received this message because you are subscribed to the Google Groups "MS 
>>EXCEL AND VBA MACROS" group.
>>To unsubscribe from this group and stop receiving emails from it, send an 
>>email to excel-macros+unsubscr...@googlegroups.com.
>>To post to this group, send email to excel-macros@googlegroups.com.
>>Visit this group at http://groups.google.com/group/excel-macros.
>>For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
>-- 
>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 Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

[Paul Schreiner]

 For your sumif(Indirect function in cell B5, try:
 
=SUMIF(INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!C18:C40"),B$3,INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!F18:F40"))
 (It should copy to D, F, H, J also)

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,
As long as ever you can.” - John Wesley
-

 From: Dileep Kumar 
>To: excel-macros@googlegroups.com 
>Cc: Haseeb Avarakkan  
>Sent: Monday, July 21, 2014 7:42 AM
>Subject: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help
>  
>
>
>Dear Friends,
>
>
>Please find attached Daily Reporting Formate of Excel in the summary sheet I 
>am unable to get the vales using indirect function.
>
>
>Please help me friends.
>
>
>-- 
>
>Regards,
>Dileep Kumar Kaza
> 
-- 
>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 Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

[Dileep Kumar]

Hi Vaibhav,

Thanks a lot for your reply. I found that what mistake I am doing.

Is there any way that we can give the reference of the date field in the
summary sheet science I have all the sheet with dates only.

That can much faster for me to finish out.



On Mon, Jul 21, 2014 at 5:45 PM, Vaibhav Joshi  wrote:

> PFA
>
> Cheers!!
>
>
> On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar  wrote:
>
>> Dear Friends,
>>
>> Please find attached Daily Reporting Formate of Excel in the summary
>> sheet I am unable to get the vales using indirect function.
>>
>> Please help me friends.
>>
>> --
>> Regards,
>> Dileep Kumar Kaza
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Regards,
Dileep Kumar Kaza

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

[Vaibhav Joshi]

what you are trying to achieve?


On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar  wrote:

> Dear Friends,
>
> Please find attached Daily Reporting Formate of Excel in the summary sheet
> I am unable to get the vales using indirect function.
>
> Please help me friends.
>
> --
> Regards,
> Dileep Kumar Kaza
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ confc question

[Vaibhav Joshi]

Did you tried macro?

It is giving same data which you highlighted in Yellow in result sheet!!
what extra you want?

Cheers!!


On Mon, Jul 21, 2014 at 4:57 PM, City Motors 
wrote:

> Sir,
> not only to our boss, all confernce log
> ex: our customer called me(my landline no) i hold that call and connect to
> you via conference call and you spoke me and my customer.
>
> means any conference log entry sir,
>
> thanks for replying soon,
>
> From:
> Vikas
>
>
>
>  On 21 July 2014 13:40, Vaibhav Joshi  wrote:
>
>>  Hey
>>
>> check this sheet, click blue button to run macro..
>>
>> When prompted enter what identifies your boss, by default i have taken
>> your example given so just enter to continue..
>>
>> On copying data you will get Msg done..
>>
>> Awaiting your feedback..
>>
>>
>> Cheers!!
>>
>>
>>  On Mon, Jul 21, 2014 at 12:54 PM,  wrote:
>>
>>>  Sir,
>>> i am working in city motors agency
>>> i enter all calls log  which i made & received in excel sheet also in
>>> register.
>>> some time customer want to talk with our senior manager( boss)
>>> than we connect to ur senior manager ( it is conference call) i
>>> highlighted with yellow color.
>>> now my request is show all conference call which is entered in sheet1 in
>>> to sheet2
>>> (logic is if date same in row than time diff  first call starts 12:04:52
>>> talk time 180 seconds means call end to 12:07:52 ( between call 12:05:46
>>>  150 seconds)
>>>  Date Time Talk Time in seconds
>>>   20-Jul-13 12:04:52 180  20-Jul-13 12:05:46 150
>>>
>>> i attached a excel sheet
>>>
>>> sir pls solve my excel problem
>>>
>>> ThanQ in advance
>>>
>>> from:
>>> Vikas
>>>
>>>
>>>  --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/gwHAXNC0UmU/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you rec

Re: $$Excel-Macros$$ confc question

[City Motors]

Sir,
not only to our boss, all confernce log
ex: our customer called me(my landline no) i hold that call and connect to
you via conference call and you spoke me and my customer.

means any conference log entry sir,

thanks for replying soon,

From:
Vikas



On 21 July 2014 13:40, Vaibhav Joshi  wrote:

> Hey
>
> check this sheet, click blue button to run macro..
>
> When prompted enter what identifies your boss, by default i have taken
> your example given so just enter to continue..
>
> On copying data you will get Msg done..
>
> Awaiting your feedback..
>
>
> Cheers!!
>
>
> On Mon, Jul 21, 2014 at 12:54 PM,  wrote:
>
>> Sir,
>> i am working in city motors agency
>> i enter all calls log  which i made & received in excel sheet also in
>> register.
>> some time customer want to talk with our senior manager( boss)
>> than we connect to ur senior manager ( it is conference call) i
>> highlighted with yellow color.
>> now my request is show all conference call which is entered in sheet1 in
>> to sheet2
>> (logic is if date same in row than time diff  first call starts 12:04:52
>> talk time 180 seconds means call end to 12:07:52 ( between call 12:05:46
>>  150 seconds)
>>  Date Time Talk Time in seconds
>>   20-Jul-13 12:04:52 180  20-Jul-13 12:05:46 150
>>
>> i attached a excel sheet
>>
>> sir pls solve my excel problem
>>
>> ThanQ in advance
>>
>> from:
>> Vikas
>>
>>
>>  --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/gwHAXNC0UmU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" 

Re: $$Excel-Macros$$ run-time error '1004': Reference is not valid.

[Paul Schreiner]

First of all, if you saved it as a "macro enabled workbook file",
that means you saved it as a .xlsm file.
If so, they could NOT have opened the file with a version of Excel prior to 
2010.
So, that just leaves a "newer" version, which I wouldn't jump to immediately.
 
Which line is showing the error?
without knowing what other macro they ran, it's hard to tell. 
The macro has (4) named ranges:
 
"GoalSeekPERSIR"
"CalPERSImpliedInterestRate"
"GoalSeekIndexIR"
"BenchmarkImpliedInterestRate"
 
It's possible that one of their other macros either deleted one or more of 
these ranges,
or perhaps you have to have the proper sheet selected for it to run.
 
The fact is, in order to determine what's going on, you have to be able to 
duplicate the issue.
"Reference is not valid"
 
well, what in the macro is a "Reference"?
Range names are references.
 
At first, I thought the error "obviously" referred to your .GoTo statements:
Application.Goto Reference:="GoalSeekPERSIR"
Application.Goto Reference:="GoalSeekIndexIR"
Application.Goto Reference:="R16C1"

But, I tested to see if this error occurred if the range name no longer existed.
Instead, I got:
"Run-time error '1004': Application-defined or object-defined error"


Slightly different, so my guess is that either the range 
"CalPERSImpliedInterestRate" or "BenchmarkImpliedInterestRate" has been deleted 
or otherwise no longer available.

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,
As long as ever you can.” - John Wesley
-

 From: deanalt via MS EXCEL AND VBA MACROS 
>To: excel-macros@googlegroups.com 
>Sent: Friday, July 18, 2014 9:18 PM
>Subject: $$Excel-Macros$$ run-time error '1004': Reference is not valid.
>  
>
>
>I sent someone an EXCEL macro enabled workbook file (created in EXCEL 2010) 
>and they ran some macros, saved the result, then later tried to run a 
>different macro and got the error message in the subject line.   I had no such 
>problem in running it just the way they did it on my computer.  It is possible 
>they have an older or newer version of EXCEL than I do, i.e., not 2010.  Below 
>is the very short macro.  Is there anything here that lends itself to not 
>working on a different version of EXCEL?
>
>
>Even if there is no clue, is there a way to change the macro, maybe by 
>declaring something or whatever, to ensure it will probably run on other 
>computers better?
>
>
>I created this macro a long time ago, am a novice at macros, and don't recall 
>if I recorded all of this macro or just some of it, then edited it.  But it 
>works for me just fine.
>
>
>Thanks so much!
>Dean
>
>
>Sub ComputeInterestRates()
>    Application.MaxChange = 0.01
>    Application.Goto Reference:="GoalSeekPERSIR"
>    Range("GoalSeekPERSIR").GoalSeek Goal:=0, 
>ChangingCell:=Range("CalPERSImpliedInterestRate")
>    Application.Goto Reference:="GoalSeekIndexIR"
>    Range("GoalSeekIndexIR").GoalSeek Goal:=0, 
>ChangingCell:=Range("BenchmarkImpliedInterestRate")
>    Application.Goto Reference:="R16C1"
>End Sub
-- 
>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 Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any secur

Re: $$Excel-Macros$$ COMPARE AND COPYING DATA(RECORDS) WITHIN TWO EXCEL SHEETS BY COMPARING TWO MORE UNIQUE VALUES

[Vaibhav Joshi]

Ok,

can you explain one example too for better inderstanding...

Cheers!!


On Mon, Jul 21, 2014 at 2:02 PM, VETRI S P  wrote:

>
>
> On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
>>
>> can you attach sample sheet to make work simpler..
>>
>> Cheers!!
>>
>
> Sir,
>
> Sample File attached
>
>
> Pl find a way to compare and copying data within sheets
>
>
>
>>
>> On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P  wrote:
>>
>>>
>>>
>>> Sir,
>>>
>>>
>>> I have two Excel sheets in which one is Master Data  Sheet other one is
>>> Normaldatasheet ( here data of two is same but all the data from Master
>>> data have to updated in NormalDatasheet)
>>>
>>> *Criteria*
>>>
>>>  Fields in two Sheets
>>>
>>>1. ServiceNo(datatype-Number)
>>>2. PolicyNo(PrimaryKey, AlphaNumeric)( may be ''Blank'' *OR*
>>> '''' *OR* Text *OR* "Wronglyentry" in NormalDataSheet)
>>>3. Premia(Number)
>>>4. DateofMaturity
>>>5. ProposalNumber(Number)(may be ''Blank'' *OR* '''' *OR* Text
>>>*OR* "Wronglyentry" in NormalDataSheet)
>>>
>>>   Explanation , Here for a Service Number there might be More than two
>>> policy Numbers ( these two policy numbers may have same rate of Premia).  I
>>> have to compare three data filelds ie- ServiceNo, PolicyNo, premia and
>>> ProposalNumber, if these parameters matched then, pick that PolicyNumber's
>>> Record(ie-Row) and paste the same against the matched value of
>>> NormalDataSheet
>>>
>>> Please guide me to create VBA
>>>
>>> It is very urgent to me
>>>
>>> Regards
>>>
>>> VETRI SP
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this m

Re: $$Excel-Macros$$ COMPARE AND COPYING DATA(RECORDS) WITHIN TWO EXCEL SHEETS BY COMPARING TWO MORE UNIQUE VALUES

[VETRI S P]

Sir,

Sample file is here

Regards

On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
>
> can you attach sample sheet to make work simpler..
>
> Cheers!!
>
>
> On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P  > wrote:
>
>>
>>
>> Sir,
>>
>>
>> I have two Excel sheets in which one is Master Data  Sheet other one is 
>> Normaldatasheet ( here data of two is same but all the data from Master 
>> data have to updated in NormalDatasheet)
>>
>> *Criteria*
>>
>>  Fields in two Sheets
>>
>>1. ServiceNo(datatype-Number)
>>2. PolicyNo(PrimaryKey, AlphaNumeric)( may be ''Blank'' *OR* '''' 
>>*OR* Text *OR* "Wronglyentry" in NormalDataSheet) 
>>3. Premia(Number)
>>4. DateofMaturity
>>5. ProposalNumber(Number)(may be ''Blank'' *OR* '''' *OR* Text 
>>*OR* "Wronglyentry" in NormalDataSheet) 
>>
>>   Explanation , Here for a Service Number there might be More than two 
>> policy Numbers ( these two policy numbers may have same rate of Premia).  I 
>> have to compare three data filelds ie- ServiceNo, PolicyNo, premia and 
>> ProposalNumber, if these parameters matched then, pick that PolicyNumber's 
>> Record(ie-Row) and paste the same against the matched value of 
>> NormalDataSheet
>>
>> Please guide me to create VBA 
>>
>> It is very urgent to me
>>
>> Regards
>>
>> VETRI SP
>>
>> -- 
>> 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 Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sample.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ COMPARE AND COPYING DATA(RECORDS) WITHIN TWO EXCEL SHEETS BY COMPARING TWO MORE UNIQUE VALUES

[VETRI S P]

On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
>
> can you attach sample sheet to make work simpler..
>
> Cheers!!
>

Sir,

Sample File attached 


Pl find a way to compare and copying data within sheets

 

>
> On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P  > wrote:
>
>>
>>
>> Sir,
>>
>>
>> I have two Excel sheets in which one is Master Data  Sheet other one is 
>> Normaldatasheet ( here data of two is same but all the data from Master 
>> data have to updated in NormalDatasheet)
>>
>> *Criteria*
>>
>>  Fields in two Sheets
>>
>>1. ServiceNo(datatype-Number)
>>2. PolicyNo(PrimaryKey, AlphaNumeric)( may be ''Blank'' *OR* '''' 
>>*OR* Text *OR* "Wronglyentry" in NormalDataSheet) 
>>3. Premia(Number)
>>4. DateofMaturity
>>5. ProposalNumber(Number)(may be ''Blank'' *OR* '''' *OR* Text 
>>*OR* "Wronglyentry" in NormalDataSheet) 
>>
>>   Explanation , Here for a Service Number there might be More than two 
>> policy Numbers ( these two policy numbers may have same rate of Premia).  I 
>> have to compare three data filelds ie- ServiceNo, PolicyNo, premia and 
>> ProposalNumber, if these parameters matched then, pick that PolicyNumber's 
>> Record(ie-Row) and paste the same against the matched value of 
>> NormalDataSheet
>>
>> Please guide me to create VBA 
>>
>> It is very urgent to me
>>
>> Regards
>>
>> VETRI SP
>>
>> -- 
>> 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 Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sample.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox

[Vaibhav Joshi]

Check this:
http://stackoverflow.com/questions/11263483/how-do-i-trigger-a-macro-to-run-after-a-new-mail-is-received-in-outlook

Cheers!!


On Mon, Jul 21, 2014 at 1:41 PM, Vaibhav Joshi  wrote:

> Hi
>
> Macro which you gave is not related to what you wanna do!!
>
> what exactly you wanna do when outlook receives email etc...
>
> Cheers!!
>
>
> On Mon, Jul 21, 2014 at 10:00 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA
> MACROS  wrote:
>
>> Dear expert,
>>
>> I have a macro
>>
>> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
>> Boolean)
>>
>>
>> 'Private Sub Workbook_beforclose()
>>
>>
>> 'Sub sendmail()
>> '(mailid As String, nm As String, flname As String)
>> Dim OutApp As Object
>> Dim OutMail As Object
>>
>> Set OutApp = CreateObject("Outlook.Application")
>>
>> Set OutMail = OutApp.CreateItem(0)
>>
>> On Error Resume Next
>> With OutMail
>> .To = "lakshman...@gmail.com"
>> .Subject = "Hello!"
>> .Body = "Dear " & nm & "," & vbNewLine & vbNewLine & "HELLO !" &
>> vbNewLine & vbNewLine & "Thank you"
>> .Attachments.Add "c:\aaa.xlsb"
>> .Send
>> End With
>> On Error GoTo 0
>> Set OutMail = Nothing
>> Set OutApp = Nothing
>>
>>
>> End Sub
>>
>>
>> Need to run macro when outlook 2007 sent/receive or refresh or mail
>> arrive in inbox
>>
>>
>>
>> Lakshman Prasad
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox

[Vaibhav Joshi]

Hi

Macro which you gave is not related to what you wanna do!!

what exactly you wanna do when outlook receives email etc...

Cheers!!


On Mon, Jul 21, 2014 at 10:00 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA
MACROS  wrote:

> Dear expert,
>
> I have a macro
>
> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
> Boolean)
>
>
> 'Private Sub Workbook_beforclose()
>
>
> 'Sub sendmail()
> '(mailid As String, nm As String, flname As String)
> Dim OutApp As Object
> Dim OutMail As Object
>
> Set OutApp = CreateObject("Outlook.Application")
>
> Set OutMail = OutApp.CreateItem(0)
>
> On Error Resume Next
> With OutMail
> .To = "lakshman...@gmail.com"
> .Subject = "Hello!"
> .Body = "Dear " & nm & "," & vbNewLine & vbNewLine & "HELLO !" & vbNewLine
> & vbNewLine & "Thank you"
> .Attachments.Add "c:\aaa.xlsb"
> .Send
> End With
> On Error GoTo 0
> Set OutMail = Nothing
> Set OutApp = Nothing
>
>
> End Sub
>
>
> Need to run macro when outlook 2007 sent/receive or refresh or mail arrive
> in inbox
>
>
>
> Lakshman Prasad
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ confc question

[Vaibhav Joshi]

Hey

check this sheet, click blue button to run macro..

When prompted enter what identifies your boss, by default i have taken your
example given so just enter to continue..

On copying data you will get Msg done..

Awaiting your feedback..


Cheers!!


On Mon, Jul 21, 2014 at 12:54 PM,  wrote:

> Sir,
> i am working in city motors agency
> i enter all calls log  which i made & received in excel sheet also in
> register.
> some time customer want to talk with our senior manager( boss)
> than we connect to ur senior manager ( it is conference call) i
> highlighted with yellow color.
> now my request is show all conference call which is entered in sheet1 in
> to sheet2
> (logic is if date same in row than time diff  first call starts 12:04:52
> talk time 180 seconds means call end to 12:07:52 ( between call 12:05:46
>  150 seconds)
>  Date Time Talk Time in seconds
>   20-Jul-13 12:04:52 180  20-Jul-13 12:05:46 150
>
> i attached a excel sheet
>
> sir pls solve my excel problem
>
> ThanQ in advance
>
> from:
> Vikas
>
>
>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


confrnc_copy row to next sheet.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

[Vaibhav Joshi]

Cheers Ashish Kumar ji!!


On Mon, Jul 21, 2014 at 10:21 AM, Ashish Kumar 
wrote:

> Hi Vaibhav,
>
> Its Great buddy.
>
>
> Regards
> Ashish
>
>
> On 19 July 2014 22:02, Vaibhav Joshi  wrote:
>
>> Check this..
>>
>> Cheers!!
>>
>>
>> On Sat, Jul 19, 2014 at 2:32 PM, Vijay  wrote:
>>
>>> Dear Team,
>>>
>>>
>>> Please Help on this to Solve this Problem !!!
>>>
>>>
>>> Regards,
>>>
>>> Vijayakumar R
>>>
>>> On Monday, July 14, 2014 3:46:45 PM UTC+5:30, Vijay wrote:
>>>
 Dear Team,

 need your help to solve this problem !!!


 1) PFA, attached File already done by this Team, but require some more
 query to be rectify


 2) This file Start Button having in ( Br ) Column, require once press
 the start button, branch name based File should

 be Split only the same Branch like ( If i select Chennai means splited
 file branch name should be available only

 Chennai branch pertains to data ) and file also attached based on the
 Branch name pertains to Branch Email ID.

 3) No need the start button to press the file, Run through only in
 Macro and Splited file this start button wont

 appear.

  Thanks in Advance.

 Regard,

 Vijay



>>>  --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to exce

Re: $$Excel-Macros$$ Need some help with creating a macro

[Vaibhav Joshi]

Hi

PFA, click on blue button to Run Macro, after that enter values & there you
go...


Cheers!!


On Mon, Jul 21, 2014 at 12:45 PM, Adrian Ion Tudor <
ion.adrian.tu...@gmail.com> wrote:

> Thanks for the quick reply,
>
> Attached a sample sheet
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi
> *Sent:* Monday, July 21, 2014 10:08 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need some help with creating a macro
>
>
>
> hey
>
>
>
> Yes we can do wat you want, can you share sample sheet..
>
>
>
> Cheers!!
>
>
>
> On Mon, Jul 21, 2014 at 12:25 PM, Hendi Cluj 
> wrote:
>
> Basically i need a macro that does the following:
>
>
>
> i have a sheet in excel with items ( about 2815 items) each item has a 6
> digit code.
>
> The sheet looks like this
>
> Row 1 : code
>
> Row 2: numeric info 1 digit
>
> Row 3: description for item
>
> Row 4: description for item
>
> Row 5: Price
>
>
>
> Now what i need is this: open new sheet and write a code ( for example
> 123456) and copy the line in the data sheet that matches this code.
>
>
>
> Can anyone help?
>
>
>
>
>
> Thank you in advance!
>
>
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/JZ957mNni9Y/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
>
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google..com/group/excel-macros
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
>
>
> This email is free from viruses and malware because avast! Antivirus
>  protection is active.
>
>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to

$$Excel-Macros$$ confc question

[citymotors2015]

Sir,
i am working in city motors agency
i enter all calls log  which i made & received in excel sheet also in 
register.
some time customer want to talk with our senior manager( boss) 
than we connect to ur senior manager ( it is conference call) i highlighted 
with yellow color. 
now my request is show all conference call which is entered in sheet1 in to 
sheet2
(logic is if date same in row than time diff  first call starts 12:04:52 
talk time 180 seconds means call end to 12:07:52 ( between call 12:05:46   
 150 seconds)
Date Time Talk Time in seconds
  20-Jul-13 12:04:52 180  20-Jul-13 12:05:46 150 

i attached a excel sheet

sir pls solve my excel problem

ThanQ in advance

from:
Vikas


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


confrnc.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Need some help with creating a macro

[Vaibhav Joshi]

hey

Yes we can do wat you want, can you share sample sheet..

Cheers!!


On Mon, Jul 21, 2014 at 12:25 PM, Hendi Cluj 
wrote:

> Basically i need a macro that does the following:
>
> i have a sheet in excel with items ( about 2815 items) each item has a 6
> digit code.
> The sheet looks like this
> Row 1 : code
> Row 2: numeric info 1 digit
> Row 3: description for item
> Row 4: description for item
> Row 5: Price
>
> Now what i need is this: open new sheet and write a code ( for example
> 123456) and copy the line in the data sheet that matches this code.
>
> Can anyone help?
>
>
> Thank you in advance!
>
>  --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.