from:"Venkat"

Job Title*  Senior Consultant | BPMI - Others | Pega

Work Location & Address*Folsom, CA 95630
Contract duration (in months)*  6+
Target Start Date*  12 Jun 2017

Job Details:

Must Have Skills (Top 3 technical skills only) * 1. Pega LBA 2. Pega DCO 3.
Pega Scrum

Detailed Job Description:
Lead Business Architect for Intel Supply Chain Engagement

Desired years of experience*:
Above 10 years

Education/ Certifications (Required):
BE, LBA

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Lead Req discussion with Business
2. Document req and specification
3. Clarify Business queries to Dev team

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Drupal/PHPfrontend Developer @ Sunnyvale, CA

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Pontoon Intake Form Requirement Details

ECMS Request Number*153054

Job Title*  Technology Lead | HTML,CSS,Javascript,Jquery,PHP,Drupal |
HTML5,CSS3,AngularJS

Work Location & Address*SunnyvaleCA94085

Sunnyvale, CA
Client Name*Apple
Contract duration (in months)*  6+
Target Start Date*  02 Jul 2017

Job Details: Contribute in requirements elicitation, creation of
application architecture document and creation of design artifacts; deliver
high quality codes, support activities related to implementation and
transition; interface with internal team and key stakeholders; analyze and
resolve issues to ensure high quality deliverables at each stage of  SDLC
WITHIN the guidelines, policies and norms of Infosys.

Must Have Skills (Top technical skills only) * 1. Angular 2 2. Angular JS

Detailed Job Description:
Developer and consultant required to design, code and test using Angular 2.

Education/ Certifications (Required):
BE
Top responsibilities you would expect the Subcon to shoulder and execute*:
1. Angular2
2. Angular JS

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for DevOps Architect @ Philadelphia, PA 19103

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title - Technical Test Lead | DevOps | DevOps
Architecture Consultancy Work Location & Address - Philadelphia PA 19103
Contract duration   - 6+
Target Start Date   - 01 Jul 2017

Job Details:

Must Have Skills
Skills Dev ops with strong system admin skills Terafoam CI integration

Detailed Job Description
Skills Dev ops with strong system admin skills helping our team to work on
AnsibleTerafoamLab SetupCI integration.

Desired years of experience
Above 10 years

Education/ Certifications
BE

Top 3 responsibilities you would expect the Subcon to shoulder and execute
Dev ops with strong system admin skills Terafoam CI integration

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Salesforce Sales cloud consultant @ Irvine, CA

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title: Consultant | CRM | SFDC Sales Cloud

Work Location & Address: Irvine, CA 92618

Contract duration (in months): 6+

Job Details:

Must Have Skills (Top 3 technical skills only) * 1. SalesForce
Configuration 2. Business Analysis 3. Apex, VF customization

Nice to have skills (Top 2 only)
1. Good coordination and communication skills 2. Experience in handling E2E
SF project life cycle

Detailed Job Description:
Salesforce BSA consultant 4 to 6 years of experience in Salesforce
functional  and  development SkillsExcellent BA skills with good
communication skillsGood Salesforce configuration skillsKnowledge of Coding
standards and best Practices in VF, Apex and governor limits   Thorough
understanding of salesforce development Life Cycle

Desired years of experience*:
Above 10 years

Education/ Certifications (Required):
BTech

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Client handling
2. requirement Analysis and execution of deliverables 3. Onshore offshore
coordination

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Insurance | Re-insurance consultant @ Martinsville, NJ

2017-06-28 Thread Venkat Naredla

Hi,
Please find the below requirement & let me know your interest with updated
resume.

 Job Description: Job Title*Consultant | Insurance | Re-insurance

Work Location & Address*Martinsville NJ 8836

Contract duration: 6+ Months

Job Details:

Must Have Skills (Top 3 technical skills only) * 1. Reinsurance 2. Nonlife
Insurance 3. Good communication screen


Detailed Job Description:
Primary Skill Reinsurance and Secondary Skill Non life Insurance

Desired years of experience*:
Above 8 years

Education/ Certifications (Required):
BE

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Requirement gathering

Will the candidate be client facing and/or working with business users?

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Project Manager with Data warehouse Testing @ Plano, TX

2017-06-28 Thread Venkat Naredla

Hi,
Please find the below position & let me know your interest with updated
resume.

Job Description: Job Title: Project Manager | Data Services Testing | Data
Warehouse Testing

Work Location & Address:Plano, TX 75024

Contract duration (in months)*  6+

Target Start Date*  03 Jul 2017


Job Details:

Must Have Skills (Top 3 technical skills only) * 1. At least 12 years of
experience with experience in handling BI Projects 2. Project planning and
scheduling, well versed with MPP 3. Project Estimation, Budgeting,
Forecast, Actuals and Resourcing

Nice to have skills (Top 2 only)
1. Good documentation and communication skills 2. knowledge on Microsoft
Office Suite , SharePoint, MS Visio

Detailed Job Description:
At least 12 years of experience with experience in handling BI Projects
Project management experience. Experience in handling multiple projects at
the same time Should be able understand the business side  and can be
business facing Status collection and reporting Project planning and
scheduling, well versed with MPP Project Estimation, Budgeting, Forecast,
Actuals and Resourcing Team Coordination, work with multiple stakeholders,
senior management. The candidate will be reporting to the clients Nationa

Education/ Certifications (Required):
BTech

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Project planning and scheduling,
2. Project Estimation, Budgeting, Forecast 3. Team Coordination, work with
multiple stakeholders, senior management

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for ETL IBM Infosphere Datastage Lead @ Hartford CT 6152

2017-06-27 Thread Venkat Naredla

Hi,
Please find the below position & let me know your interest with updated
resume.

Job Description: Job Title: Technology Lead | ETL & Data Quality | IBM
Infosphere Datastage

Work Location & Address:Hartford CT 6152

Contract duration (in months)* 6+


Job Details:

Must Have Skills (Top 3 technical skills only)

1. Big Integrate

2. Datastage 11.5

3. Foundational Hadoop knowledge



Detailed Job Description:

Subcon should have a strong knowledge in datastage, especially Datastage
11.5. Also good knowledge of big integrate and hadoop


Education/ Certifications (Required):

Btech or equivalent



Top 3 responsibilities you would expect the Subcon to shoulder and execute*:

1. Design and Development

2. Anticipate, understand and respond to the needs of internal and external
clients to meet or exceed their expectations 3. 3.Team lead. Work
cooperatively and effectively with the project team

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Java/J2ee developer with Mobile Development @ Bentonville AR

2017-06-27 Thread Venkat Naredla

Hi,
Please find the below position & let me know your interest with updated
resume.

Job Description: Job Title* Technology Analyst | Java | J2EE

Work Location & Address* Bentonville AR 72716

Duration: 6+ Months


Job Details:

Must Have Skills (Top 3 technical skills only) * 1. Nodejs 2. Reactjs 3.
Java



Detailed Job Description:

Mobile Web development using Node.js and react.js skillset


Top 3 responsibilities you would expect the Subcon to shoulder and execute*:

1. Client interfacting

2. development and testing

3. reporting



-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Hadoop Architect @San Jose, CA

2017-06-26 Thread Venkat Naredla

Hi,



I do have a position of a common Hadoop architect position with our client
based at San Jose, CA.


Role: Hadoop Archtect

Location: San Jose, CA

Duration: 6+ Months



Please let me know your availability with updated resume with below details.



Work Authorization:

D.O.B:

Current Location:

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Java/J2ee developer @ Irving TX

2017-06-22 Thread Venkat Naredla

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title* Technology Analyst | Java | J2EE

Work Location & Address* Irving TX 75038
Contract duration (in months)*  6+

Job Details:

Must Have Skills (Top 3 technical skills only) * 1. Java 2. J2EE 3.
Javascript

.

Desired years of experience*:
Above 8+ years

Education/ Certifications (Required):
Btech or equivalent

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Application Dev
2. Application Maintenance


-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for ETL & Data Quality | IBM InfoSphere DataStage @ Hartford, CT

2017-06-21 Thread Venkat Naredla

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title: Technology Lead | ETL & Data Quality | IBM
Infosphere Datastage

Work Location & Address:Hartford CT 6152

Contract duration (in months)*  6+
Target Start Date:10 Jul 2017


Job Details:

Must Have Skills (Top 3 technical skills only)

1. Big Integrate
2. Datastage 11.5
3. Foundational Hadoop knowledge


Detailed Job Description:

Subcon should have a strong knowledge in datastage, especially Datastage
11.5. Also good knowledge of big integrate and hadoop

Education/ Certifications (Required):
Btech or equivalent

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Design and Development
2. Anticipate, understand and respond to the needs of internal and external
clients to meet or exceed their expectations 3. 3.Team lead. Work
cooperatively and effectively with the project team
-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Business Intelligence - Visualization | Tableau @ Sunnyvale, CA

2017-06-21 Thread Venkat Naredla

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title*Technology Analyst | Business Intelligence -
Visualization | Tableau

Work Location & Address*Sunnyvale CA94085

Contract duration (in months)*  24
Target Start Date*  17 May 2017

Job Details:

Must Have Skills (Top 3 technical skills only) * 1. Tableau 2. Requirement
Analysis, Design and Data Modelling 3. Client Interfacing

Detailed Job Description:
Good project experience in Tableau or any leading Reporting tool. Able to
work with Client and understand requirements. Coordination with offshore
for deliverables


Education/ Certifications (Required):
Graduate  or Post Graduate
Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Requirements Gathering and Analysis
2. Design and Build Reports
3. Onsite and Offshore Coordination

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for Java/J2ee Developer @ Bentonville, AR

2017-06-19 Thread Venkat Naredla

Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title* Technology Analyst | Java | J2EE

Work Location & Address* Bentonville AR 72716



Job Details:



Must Have Skills (Top 3 technical skills only) * 1. Nodejs 2. Reactjs 3.
Java



Detailed Job Description:

Mobile Web development using Node.js and react.js skillset



Education/ Certifications (Required):

BE



Top 3 responsibilities you would expect the Subcon to shoulder and execute*:

1. Client interfacting

2. development and testing

3. reporting

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Sr. Recruiter and Business Development Manager (Sales Professional) Requirements for FLUXTEK SOLUTIO

2017-05-05 Thread Venkat j

Hi Team,


We are looking for Sr. Recruiter and Business Development Manager (Sales 
Professional) Requirements  is for our Hyderabad Indian location. Please 
take a look at below details JD and if you are interested send me current 
salary package and expected salary package, availability to start / notice 
period, best time to reach and updated resume.

JD for Sr. Recruiter:

We are looking for candidates who are highly motivated to grow in the IT 
Staffing Sales Industry. In this role you will be meeting with new and 
existing clients on a daily basis, working to grow one of our largest 
existing accounts and break new accounts, ultimately growing the business 
by working with your Recruiting team to place top IT Professionals in open 
positions with reputable companies. If you are sales minded, goal driven 
and motivated to make a mark in this booming industry, we want to talk to 
you!

Business Development Manager (Sales Professional) Requirements:
5+ Years of Staffing Sales Experience
Bachelor’s Degree Required
Demonstrated ability to lead others and work as a team player
Enjoys a culture that requires accountability and personal responsibility
Attention to detail and follow up
Exhibits proven communication and presentation skills
Able to interact with and build relationships with individuals at all 
levels, including peers, clients and upper management
Able to deliver top talent with a high sense of urgency and a commitment to 
do whatever it takes to service the customer

Job Responsibilities:


The primary role of the BDM is to prospect and drive additional business 
opportunity within their defined territory/market and continuously elevate 
company’s position and market share.
The BDM will focus on acquiring new and growing existing business within 
the territory while providing exceptional service to clients and 
contractors.
Additionally the BDM will work closely with recruiters demonstrating 
leadership, mentoring and developing when appropriate.
Our rapid growth allows employees to hit the ground running and quickly 
advance into positions of increased responsibility and leadership.
Fluxtek offers a competitive compensation, bonus and benefits package to 
applicants.
Business Development Manager Key Words:
Recruiting, Sales, Business Development, Staffing, Customer Service, 
Account Management, Relationship Building, Negotiation, Marketing, 
Delivery, IT, Information Technology



Thanks and Regards,
venkat,
*Fluxtek Solutions Inc.*

Ph:9705707707 (venkatesh) & 8008692710(venkat)

Email: *venkat.re...@fluxteksol.com* <su...@fluxteksol.com>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Fluxtek Solutions Available consultants Hot-List

2017-05-02 Thread Venkat j



Hi,

 

Hope you are doing great!.

 

This is *venkat* from Fluxtek Solutions. 

Below are my available consultants Hotlist. Kindly send the suitable 
requirements and also add me in your mailing list. We do have additional

consultants available as well. Please send your requirements only to 
venkat.re...@fluxteksol.com  You can reach me at Direct : 8008692710.  Ph : 
8325582010 
EXT 113


*NAME*

*TECHNOLOGY*

*LOCATION*

*STATUS*

*RELOCATION*

*R VIJAY*

*JAVA*

*CONNECTICUT*

*H1B*

*OPEN*

*BHAVANA*

*SAP MM*

*TEXAS*

*H1B*

*OPEN*

*DEVIKA*

*SAP BASIS  HANA*

*KANSAS*

*H1B*

*OPEN*

*SANDEEP*

*SAP BI-BW HANA*

*WILLINGMTON*

*H1B*

*OPEN*

*RAVI*

*SAP FUNCTIONAL*

*CALIFORNIA*

*H1B*

*OPEN*

*AVINASH PALERU*

*SAP SECURITY*

*PORTLAND*

*H1B*

*OPEN*

*SWETHA RAMA*

SAP SECURITY AND GRC LEAD

*NEWARK*

*H1B*

*OPEN*

*VINEELA MUDDANA*

*SR. INFORMATICA DEVELOPER*

WASHINGTON

H1B

OPEN

*SIDDARDHA*

*SFDC*

*ATLANTA GA*

*EAD*

*OPEN*

*KARTHIK*

*COGNOS*

*TEXAS*

*EAD*

*OPEN*

*SAHITHI POGULA*

*.NET DEVELOPER*

*HOUSTON*

*EAD*

*HOUSTON*


Thanks and Regards,
Venkat,
*Fluxtek Solutions Inc.*

Ph:8325582010 ext 113

Email: *venkat.re...@fluxteksol.com* <su...@fluxteksol.com>

*www.fluxteksol.com* <http://www.fluxteksol.com/>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Fluxtek Solutions Updated & Available Hot-List

2017-04-27 Thread Venkat j



Hi,

 

Hope you are doing great!.

 

This is *venkat* from Fluxtek Solutions. 

Below are my available consultants Hotlist. Kindly send the suitable 
requirements and also add me in your mailing list. We do have additional

consultants available as well. Please send your requirements only to 
venkat.re...@fluxteksol.com  You can reach me at Direct : 8008692710.  Ph : 
8325582010 
EXT 113


*NAME*

*TECHNOLOGY*

*LOCATION*

*STATUS*

*RELOCATION*

*KARTHIK*

*COGNOS*

*TEXAS*

*EAD*

*OPEN*

*R VIJAY*

*JAVA/ J2EE*

*CONNECTICUT*

*H1B*

*OPEN*

*SAHITHI*

*.NET DEVELOPER*

HOUSTON

*EAD*

*NO*

*SIDDARDHA*

*SFDC*

*ATLANTA GA*

*EAD*

*OPEN*



Thanks and Regards,
venkat,
*Fluxtek Solutions Inc.*

Ph:8325582010 ext 113

Email: *venkat.re...@fluxteksol.com* <su...@fluxteksol.com>
*www.fluxteksol.com <http://www.fluxteksol.com/>*

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need support

2016-11-30 Thread Venkat CV

VLOOKUPNTH is user defined function?

On 01-Dec-2016 11:35 AM, "Murali Nagarajan"  wrote:
>
> Dear team,
>
> Below mentioned formula is not working properly.how to use the formula
> =VLOOKUPNTH($E2,$A$2:$C$209,3,10)
> Note: File has been attached
>
> regards
>
> N.Murali
>
> --
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Forum rules : Please adhere else you will be BANNED

2013-04-19 Thread venkat

Mr. Jain

good rules.
is thre any facility to attach a very small data in excel format (not 
image) in this newsgroup.
It would be better that those who need help post a very small extract of 
data in excel format and explain  so lthat data can be copied to an excel 
sheet and soluion (macro or formula0 wirtten and tested and sent.
for security reason they can fill the cells with random data instead of 
actual data.


On Saturday, July 23, 2011 5:50:06 PM UTC+5:30, Ayush Jain wrote:

 Hello everyone,
  
 Please adhere to below rules of the forum. You will be banned without 
 warning on non compliance.
 Till date 806 members are banned in group, This is the reason the group is 
 spam free.
  
*Please read and adhere to these simple rules!*
 *
 1. Use concise, accurate thread titles. *Your post title should describe 
 your problem, not your anticipated solution. Use terms appropriate to a 
 Google search. 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* -- start your 
 own. If you feel it's particularly relevant, provide a link to the other 
 thread.

 *3. Don't Private Message* or email questions to moderators or other 
 members. The point of having a public forum is to share solutions to common 
 (and sometimes uncommon) problems with all members.

 *4. Common courtesy is the order of the day*. Avoid coarse language 
 (meaning any words you didn't hear in Sunday school), provide feedback to 
 suggested solutions, and take the time to thank those who took their time 
 to help you. If you solve a problem yourself before anyone else has 
 responded, please take a moment to describe your solution -- chances are 
 some other member will benefit.

 *5. Don't post questions regarding breaking or bypassing any security 
 measure.* Such posts will be deleted, and repeat offenders will be 
 banned. This includes posting of links to sites that offer software, code 
 or services to do this or posting of code to remove passwords.

 *6. Acknowledge the responses you receive, good or bad.*

 *7. Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. *

 *8. Any post which is not related to excel, macros, vba, access or any 
 other office technology, It will be considered as spam on the discretion of 
 moderators.*

 *General suggestions:*
  
1. *Don't put your email address in a post unless you're dying for 
more spam in your inbox.
* 
2. *Don't ever post personal or confidential data in a workbook. The 
moderators will not consider any request to delete such posts.*

  
 Feel free to let me know if you have any doubts or if you want to add more 
 rules to keep this forum clean.
  
 The rules are also available @ this 
 linkhttp://www.discussexcel.com/google-group/forum-rules
  

 Best regards,
 Ayush Jain
 Group Manager, MVP


-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-03 Thread Venkat CV

Congrats Noorian...



-- 
*Best Regards,*
*Venkat *
*Chennai*


On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain jainayus...@gmail.com wrote:

 Dear members,

 Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
 the month of Aug'12. He has posted 111 posts in August 2012 and helped many
 forum members through his excel expertise.
 I truly appreciate his consistency and commitment to the group. He is
 really doing great job.
 *Noorain, please find enclosed the award certificate in honour of your
 contribution.*

 Thanks to all other folks for helping excel enthusiasts voluntarily !!
 Keep posting.

 Regards,
 Ayush Jain
 Group Manager
 Microsoft MVP

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.






*
*
*
*
*
*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-06 Thread Venkat CV

Congrats Noorain.

-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*


On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote:

 Dear members,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month of
 July'12. He has posted 143 posts in July 2012 and helped many forum members
 through his excel expertise.

 I truly appreciate his consistency and commitment to the group. He is
 really doing great job.

 Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
 Sunita and other folks for helping excel enthusiasts voluntarily !!
 Keep posting.

 Regards,
 Ayush Jain
 Group Manager
 Microsoft MVP

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com






*
*
*
*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Zip Files in Folder with password

2012-07-05 Thread Venkat CV

Dear All,

I want to Compress all the files(.zip) to the specified folders with the
password..Where i will have a passwords towards that file names..

have attached sample Password list..

I need a VBA Code...



-- 
*Best Regards,*
*Venkat *

*
*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Password_List.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-03 Thread Venkat CV

Congrats..Ashish  Dilip

*Best Regards,*
*Venkat *
*Chennai*

On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote:

 Dear members,

 I am extremely happy to inform you that two members of the group are
 awarded Microsoft Most Valuable Professional Award.
 My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
 thanks for their big support to this forum.

 Keep posting !

 Best regards,
 Ayush Jain
 Group Manager
 Microsoft MVP




 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




-- 

*
*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need Formula !!

2012-06-27 Thread Venkat CV

Hi Iqbal,

Try this *=IF(E2=Qualify,-,C2-D2)*

-- 
*Best Regards,*
*Venkat *
*Chennai*



On Wed, Jun 27, 2012 at 6:46 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:

 Dear Exports,

 Please find attached a file and help for formula as per required.





 Regards,

 Iqbal Shaikh

  --
 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com






*
*
*
*
*
*

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Need Formula Venkat.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया. FIVE YEARS COMPLETIONTHANK YOU**

2012-03-22 Thread Venkat CV

Dear Noorain,

Superb

*Best Regards,*
*Venkat *
*Chennai*

2012/3/23 NOORAIN ANSARI noorain.ans...@gmail.com

जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
जहाँ Question,Answer करने की,है खूब आज़ादी.
जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया.
दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया.
चाहे सुबह हो या शाम, चाहे दिन हो या रात.
हर समय होती है यहाँ पोस्टिंग की बरसात.
ये उपवन सजा है दोस्तों, कई Talented फूलों से.
यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
Logic की खेती होती है यहाँ solutions के खलिहानों में.
यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
*Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
Man of BT *Krishna* के solution को दुनिया तरसती है.
*ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
*Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
और भी यहाँ बहूत सारी शख्सियत है निराली.
*Ayush* बाबू करते है इस बगीया की रखवाली.
ये forum अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.

दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.

--
Thanks regards,
Noorain Ansari
** http://excelmacroworld.blogspot.com/*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

--
FORUM RULES (986+ members already BANNED for violation)

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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

--
*
*
*
*
*
*

--
FORUM RULES (986+ members already BANNED for violation)

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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

2012-03-22 Thread Venkat CV

Hi ,

See below link..

http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra rajafs...@gmail.com wrote:

 hi all

 i am looking for some vba codes which will search html files (bases file
 names in the sheet) from specified locations and paste the path of the same
 file as hyperlink in the sheet

 Thanks


  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Pivot Table

Hi Karan,

Try to download *Excel 2007 PivotTables Recipes.pdf * book by 2007 by Debra
Dalgleish

Or you can search in youtube for Video's tutorial..

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Tue, Mar 20, 2012 at 2:59 PM, Shaik Waheed waheedb...@gmail.com wrote:

 Hi,
 Check out the below link

 http://www.contextures.com/CreatePivotTable.html

 On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh karan1...@gmail.com wrote:

 Dear All,

 Kindly send me some pivot table examples. I want to learn it.


 Thanks
 Kaяan

 http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
 https://plus.google.com/43524614789164919/posts


 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ lotus notes email

Hi Prabhat,

Try Below links..

http://www.mrexcel.com/forum/showthread.php?t=62381
http://www.ozgrid.com/forum/showthread.php?t=36812

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*



On Tue, Mar 20, 2012 at 4:17 PM, prabhat.shrivasta...@gmail.com 
prabhat.shrivasta...@gmail.com wrote:

 Dear all, pl help me to get the e mail ids that mentioned in a excel to
 copy at recipient of lotus notes...

 Say suppose that e mail ids mentioned in a excel particular cell i.e. cell
 c1, i want that all email ids get copied and paste at receipint of lotus
 note...

 Thanks fot your help in advace.

 Regards,
 Prabhat S

 --
 FORUM RULES (986+ members already BANNED for violation)

 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)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ sms or text sms in excel.

Hi,

Please have a look on below link..

http://www.tricksmachine.com/2009/07/send-sms-online-from-your-excel-sheet.html



On Sat, Mar 17, 2012 at 12:56 PM, Deba Ranjan drdeva...@gmail.com wrote:

 *
 *
  Dear expert,

 I am looking out for sending text sms to numbers by the help of excel.
 Please help me to send sms by the hlp of excel.



 *Regards*

 *Deba Ranjan P**
 *
 *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]***

 ^^ஜ۩۞۩ஜ▬▬▬ ▬^^

 * *
 *
 *

  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
image001.gif

Re: $$Excel-Macros$$ XL 2010 to XL 2007 compatibility question

Hi Dave,

Actually Excel 20072010 or more or less Samefile Format options..You dont
need to install any Compatibility package and all ...

You can just Save files as a *.XLSX,.XLSM.*..You will not fild any problems
on this..

Also you can set default file  save option as .XLSX .

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Tue, Mar 20, 2012 at 9:00 PM, DaveO dmo...@gmail.com wrote:

 Our department has started using XL 2010, and we must respond to a
 client's proposal using XL 2007. Based on this article by Microsoft,
 http://technet.microsoft.com/en-us/library/cc179167.aspx, we can create a
 file in 2010, avoid the new statistical functions, sparklines, slicers,
 conditional formatting, etc., and the client will be able to read our file
 using XL 2007. Do I understand this correctly?

 Thanks,
 Dave O

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Exl at expert level

Hi Maries,

Nice Collections...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Sun, Mar 18, 2012 at 1:53 PM, Maries talk2mar...@gmail.com wrote:

 Hi,

 *Check below Weblinks.*

   *MVP's* *Web Link*  Alan Beban   
 http://home.pacbell.net/bebanhttp://home.pacbell.net/beban  Allen
 Wyatt   http://excel.tips.net http://excel.tips.net/  Andrew Engwirda
  http://www.andrewsexceltips.net/ http://www.andrewsexceltips.net/  Andy
 Pope   http://www.andypope.info/ http://www.andypope.info/  Ashish Koul
  http://akoul.blogspot.com http://akoul.blogspot.com/  Ashish Mathur
  http://www.ashishmathur.com http://www.ashishmathur.com/  Ayush Jain
  http://www.discussexcel.com http://www.discussexcel.com/  Bernd Held
  http://members.aol.com/Machero http://members.aol.com/Machero  Charley
 Kyd   http://www.exceluser.com/ http://www.exceluser.com/  Chip Pearson
  http://www.cpearson.com http://www.cpearson.com/  Daniel Ferry
  http://www.excelhero.com/ http://www.excelhero.com/  Daniel Josserand
  http://dj.joss.free.fr/ http://dj.joss.free.fr/  David McRitchie
  
 http://www.mvps.org/dmcritchie/excel/excel.htmhttp://www.mvps.org/dmcritchie/excel/excel.htm
   Debra
 Dalgleish   
 http://www.contextures.com/tiptech.htmlhttp://www.contextures.com/tiptech.html
   Dick
 Kusleika   http://www.dailydoseofexcel.com/http://www.dailydoseofexcel.com/ 
  Dilip
 Pandey   
 https://mvp.support.microsoft.com/profile/Dilip.Kumar.Pandeyhttps://mvp.support.microsoft.com/profile/Dilip.Kumar.Pandey
   Ed
 Ferrero   http://www.edferrero.com http://www.edferrero.com/  Fernando
 Cinquegrani   http://www.prodomosua.eu http://www.prodomosua.eu/  Frank
 Isaacs   http://www.vbapro.com http://www.vbapro.com/  Jake Marx
  http://www.longhead.com/ http://www.longhead.com/  Jan Karel Pieterse
  http://www.jkp-ads.com http://www.jkp-ads.com/  John Lacher
  http://www.lacher.com http://www.lacher.com/  John Walkenbach
  http://spreadsheetpage.com http://spreadsheetpage.com/  Jon Peltier
  http://www.peltiertech.com/ http://www.peltiertech.com/  Jorge
 Rodrigues   http://exceler.blogspot.com http://exceler.blogspot.com/  Ken
 Puls   http://www.excelguru.ca http://www.excelguru.ca/  Laurent Longre
  http://xcell05.free.fr http://xcell05.free.fr/  Masaru Kaji
  http://puremis.net/excel/ http://puremis.net/excel/  Mike Alexander
  http://www.datapigtechnologies.com http://www.datapigtechnologies.com/  
 Monika
 Weber   http://www.jumper.ch http://www.jumper.ch/  Nick Hodge
  http://www.nickhodge.co.uk http://www.nickhodge.co.uk/  Nick Vivian
  http://ExcelExperts.com http://excelexperts.com/  Orlando Magalhães
 Filho   http://orlando.mvps.org http://orlando.mvps.org/  Patrick
 Molloy   http://www.xl-expert.com http://www.xl-expert.com/  Rob Bovey
  http://www.appspro.com http://www.appspro.com/  Robert Rosenberg
  http://www.r-cor.com http://www.r-cor.com/  Rodney Powell
  http://www.beyondtechnology.com http://www.beyondtechnology.com/  Ron
 de Bruin   http://www.rondebruin.nl http://www.rondebruin.nl/  Somkiat
 Foongkiat   
 http://www.ExcelExpertTraining.comhttp://www.excelexperttraining.com/  
 Stephen
 Bullen   http://www.oaltd.co.uk http://www.oaltd.co.uk/  Thomas Ramel
  http://users.quick-line.ch/ramel/ http://users.quick-line.ch/ramel/  Ture
 Magnusson   http://www.turedata.se http://www.turedata.se/  Tushar
 Mehta   http://www.tushar-mehta.com http://www.tushar-mehta.com/  Zack
 Barresse   http://www.vbaexpress.com http://www.vbaexpress.com/

 Regards,

 MARIES.

 On Sun, Mar 18, 2012 at 12:00 PM, sandhya jain sanya...@gmail.com wrote:

 Hi Expert.

 I want to learn exl at expert level. Help me.


 Regards,
 Sandhya


 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 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

Re: $$Excel-Macros$$ Query (Remove duplicate)

Hi Karan,
Try Advanced filter and select Unique records..And you can Copy and paste
it in New Column..

[image: Inline image 1]


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh karan1...@gmail.com wrote:

 Dear All,

 I need you assistance, I want to remove duplicate value from column A to
 B. I'v attached the test file. Kindly help me in this.


 Kaяan

 http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
 https://plus.google.com/43524614789164919/posts


  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
image.png

Re: $$Excel-Macros$$ last copied item in windows clipboard

Hi Divakar,

Copy data twice You will get Clipboard..You Can see Last Second Copied Data.

 [image: Inline image 1]

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Mon, Mar 19, 2012 at 5:23 PM, Divaker Pandey divake...@gmail.com wrote:

 Hi Expert,

 Can anyone give me a hint to findout last and second last copied item.


 Divaker

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
image.png

Re: $$Excel-Macros$$ copy paste in reverse order

Hi Amit,

Try Transpose Option on Paste special..if Helps..

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:

  Hi,

 ** **

 Is there any formula to copy data from say 2 rows say 1  2  paste them
 in reverse order. Data of 1st row will move to 2nd  of 2nd row to first..
 

 ** **

 Best Regards,

 Amit

 ** **

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Missing serial number

2012-03-16 Thread Venkat CV

Hi Nilesh,

Try this Below...

*=IF(A3=A2+1,Ok,A2+1)*

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Fri, Mar 16, 2012 at 10:40 AM, Virkar,Nilesh nil...@lechlerindia.comwrote:

 Dear All,

 ** **

 I need to find out the missing serial number from the attached column. So
 do anybody have any idea about the formula ?

 ** **

 Thanks  Regards

 ** **

 Nilesh Virkar

 *P** **please consider the environment before printing this e-mail. Thank
 you*



 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Venkat CV

Congrats Noorain:)

On 3/15/12, Ayush Jain jainayus...@gmail.com wrote:
  Hello Everyone,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month of
 Feb'12
 He has posted 156 posts in Feb'12 and helped many people through his
 expertise. He has been consistent contributor to this excel forum but has
 acheived this recognition for third time.

 *About Noorain Ansari :*
 [image: noorain.jpg]

 Noorain is a great poet and keep sharing his thoughts on different topics
 throgh cool poems. Professionally, he is a Excel aficionado and presently
 working as senior business analyst in One97 Communication Ltd. He is a MS
 excel - vba expert and keep sharing his thoughts with this forum. You can
 follow his blogs for Excel knowledge and cool poems :
 www.excel-macro.blogspot.com  www.noorain-ansari.blogspot.com

 *Noorain, Many thanks for all your great support to group. Keep it up*

 *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up !!
 **
 *Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

 --
 FORUM RULES (986+ members already BANNED for violation)

 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)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
 *Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ date format

2012-02-26 Thread Venkat CV

Hi ,

Try This,


*=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))*

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.com wrote:

 i have date in this format-- 20011012... yrmmdd..  i want to extract week
 no and month from this date. what is the formula

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Difference between VBA and VSTO

2012-02-12 Thread Venkat CV

Hi Hanumanth,

Look Below Link

http://netindonesia.net/blogs/andriyadi/archive/2008/08/20/vba-vs-vsto.aspx

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*



On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde arsfan2...@yahoo.co.inwrote:

 Hi,

 Can somebody please tell me what is the difference between VSTO and VBA.

 I have heard VBA has left short life after Office 2010 is released.

 Can somebody please explain how much is the truth or what are the chances
 and etc, etc 

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help

Dear Sriram,

Look attached...as required...





On Thu, Feb 2, 2012 at 6:38 PM, sriram ji sriramg...@gmail.com wrote:

 Dear Excel Guru,

 Kindly provide the solution for the attached file.

 Thanks  Regards,
 Sriram G
 Chennai

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Sriram Need Help---Resolved.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

Hi Sanjib,

Look Attached...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee 
chatterjee.kolk...@gmail.com wrote:


 Dear Experts,

 Please See the attachment and Help me regarding VLOOKUP FUNCTION

 Thanking you in Advance

 Sanjib









 --
 -

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


VLOOKUP_FUNCTION Venkat.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats...

Noorain  Everyone...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote:

 Hello Everyone,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month of
 Jan'12
 He has posted 175 posts in Jan'12 and helped many people through his
 expertise. He has been consistent contributor to this excel forum but has
 acheived this recognition for first time.

 *About Noorain Ansari :*
 [image: noorain.jpg]

 Noorain is a great poet and keep sharing his thoughts on different topics
 throgh cool poems. Professionally, he is a Excel aficionado and presently
 working as senior business analyst in One97 Communication Ltd. He is a MS
 excel - vba expert and keep sharing his thoughts with this forum. You can
 follow his blogs for Excel knowledge and cool poems :
 www.excel-macro.blogspot.com  www.noorain-ansari.blogspot.com

 *Noorain, Many thanks for all your great support to group. Keep it up*

 *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
 , Priyanka, Lokesh and other folks for helping excel enthusiasts
 voluntarily !! Keep it up !!
 **
 *Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
noorain.jpg

Re: $$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

Hi Muneer,

Can u Explain some more about query...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Sat, Feb 4, 2012 at 10:59 AM, Mohammed Muneer mmun...@ccc.com.qa wrote:

 **





 Regards,
 Muneer,
 CC...

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ help

2012-01-28 Thread Venkat CV

Hi Vijay,

Look Below about relative refrence..

*What are the types of references?*1. Absolute Column/Absolute Rowe.g.
$A$1means
Whether you use auto-fill across column or across row, the reference won't
be changed.
2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across
column, it will remain column A but when you auto-fill across row, the
reference will change to $A2, $A3, $A4 and so on.
3. Relative Column/Absolute Rowe.g. A$1means When you use auto-fill across
row, it will remain row 1 but when you auto-fill across column, the
reference will change to B$1, C$1, D$1 and so on.
4. Relative Column/Relative Rowe.g. A1means When you use auto-fill across
column, the reference will change to B1, C1, D1 and so on and when you
auto-fill across row, the reference will change to A2, A3, A4 and so on.*How
to change the reference?*1. Prefix with $ manually.2. Right after entering
the formula use F4 to toggle between the four kinds of references.
(recommended)
*Where to use?*You can use it in formula or function in Excel spreadsheet,
rest depends on your logic.


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Sat, Jan 28, 2012 at 11:21 AM, vijayajith VA vijayajith...@gmail.comwrote:

 Hello sir,


 Just i want to know about use relative reference in  vb developer tab.?
 What is use of that ?

 Thanks in advance
 '

  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

2012-01-04 Thread Venkat CV

Congrats...Rajan All...

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Wed, Jan 4, 2012 at 11:29 PM, Ayush Jain jainayus...@gmail.com wrote:

 Sam, Welcome back to the group. We missed you.

 Noorain, I liked the poetic wishes. Keep it up.

 Thanks everyone for being the part of this group.

 Regards
 Ayush Jain




 On Wed, Jan 4, 2012 at 11:20 PM, Aamir Shahzad 
 aamirshahza...@gmail.comwrote:

 Congratulates Rajan. Wellcome back SAM.


 On Wed, Jan 4, 2012 at 7:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  Thank you all.



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *SWADHEEN JAIN
 *Sent:* Jan/Wed/2012 02:27
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member-
 Dec'2011



 Thank you Rajan ji for your devotion and time for the group.



 God bless you.



 Swadheen Jain

 On Wed, Jan 4, 2012 at 12:59 PM, Maries talk2mar...@gmail.com wrote:

 *Congrats Rajan!*



 On Wed, Jan 4, 2012 at 10:37 AM, Asa Rossoff a...@lovetour.info wrote:

 Congratulations, Rajan!   You bring a lot to the group -- you're very
 generous with your time and expertise.



 Much respect.



 Asa



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
 *Sent:* Tuesday, January 03, 2012 10:21 AM
 *To:* excel-macros
 *Subject:* $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011



 Hello Everyone,



 Wish you a very happy new year !!


 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 December'2011
 He has posted 105 posts in December2011 and helped many people through
 his expertise. He has been consistent contributor to this excel forum and
 has acheived this recognition third time.



 He is back after long time but we all want him to continue his voluntary
 contribution in 2012 as well.


 Thanks to Don, Noorain, and other folks for helping excel enthusiasts
 voluntarily !! Keep it up !!

 Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com



 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com



 --
 FORUM RULES (986+ members already BANNED for violation)

 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

$$Excel-Macros$$ Fwd: Job

2011-11-21 Thread Venkat CV

-- Original message --
From:Hewlett-Packard India Pvt Ltd ghulam-mohammed.huss...@hp.com 
Date: 21 Nov 11 16:12:45
Subject: Openings @ Hewlett Packard (HP) for SQL DBA- CHENNAI LOCATION
To:

 The sender of this email is registered with Naukri.com as Hewlett-Packard
India Pvt Ltd

*Experience required for the Job:* 3 - 6 years
*Job Location:* Chennai

*Dear Candidate,*

Hi,

Greetings from HP.

We at Hewlett-Packard offer you the best work environment where you can
learn, grow and contribute to the success story. Yes, we are back with
opportunities for you to make your dreams a reality, make anything
possible.

HP is hiring SQL DATABASE ADMINISTRATOR for CHENNAI Location. Kindly go
through the requirements and revert with your updated resume.

Experience: 3 to 6 Yrs

LEVEL 2 SUPPORT

Work Location : CHENNAI

If interested kindly mail across your updated profile to
ghulam-mohammed.huss...@hp.com along with following mandatory details:

Total Exp:
Relevant Exp in Core SQL DBA:
Current CTC
Expected CTC:
Education Qualififcation:
Updated Contact No
Openness to relocate to CHENNAI:
Current Location:

Job description

You'll be making significant contributions to the overall success of
projects, whether the optimum solutions involve people, process or
technology.

Delivering tremendous differentiated and perceived value to customers,
you'll ensure that hp provides them with the best overall service
experience in the industry¢¢â€š¬¦not only ensuring that projects run to
plan, but also identifying opportunities to provide even greater value
through expanded engagements or new consulting opportunities.

This will involve working exceptionally closely with customers, sharing
knowledge, leveraging hp's experience and knowledge, and driving the
creation of structured intellectual capital.

SQL Server 2000/2005/2008 (MCDBA/MCTS) certified with exposure to 24*7
Production support.
Working Knowledge of Oracle Desired

1. Substative (3- 6 years) experience providing database administration in
the following environments - MS SQL Server 2000/2005/2008.

2. Expertise on Installation, Backup, Restores/ refreshes, etc.

3. Must have worked on Log shipping, Replication, DB Mirroring, Migration,
performance tuning, Cluster environment and DTS/SSIS.

4. Expertise in mentoring and coaching peers.

5. Ability to deal with conflicting deadlines on a regular basis when
managing work packages associated with projects.

6. Proven experience in Database Technologies and able to Architect /
Design / implement a DB solution which meet client requirement of High
Availability, Performance and Reliability in one or more of the following,
Oracle, DB2 UDB, MS SQLServer, Sybase and Informix.

7. Good working knowledge of Windows XP/2000/2003 Operating environments.

8. Ability to utilize various tools to provide system management functions
such as: system backup/recovery, code promotion, system monitoring.

9. Ability to perform software upgrades, and apply patches.

10. Ability to formulate overall strategies and support development effort
in areas of major difficulties and organizational complexity.

11. Risk awareness is vital. A simple change can have major unintended
consequences.

12. University Degree or College Diploma in Information Systems and
demonstrated experience in the field of Information Technology.

13. Recognized Leadership/Management skills for working in a stressful
environment.

GENERAL

1. Risk awareness is vital. A simple change can have major unintended
consequences.

2. Exercise judgement and analysis to arrive at recommendations or
conclusions.

3. Thorough knowledge of business application, strategic business and I.T.
strategic direction and technology disciplines.

4. Excellent verbal and written skills

5. High level of initiative with strong organizational skills.

6. Excellent interpersonal skills and team orientation.

7. Strong leadership and motivating skills

8. Excellent time management skills

9. Ability to make formal presentations

10. Ability to deal with complex technical issues

If the positions are irrelevant to you, please help refer your friends who
would be interested to be a part of HP.

Thanks  Regards,

Ghulam Md Hussain

Hewlett Packard India, Staffing

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data

$$Excel-Macros$$ Opening for MIS

2011-11-21 Thread Venkat CV

-- Original message --
From:Absolute HR Solutions Pvt. Ltd. praja...@absolutehrs.com 
Date: 21 Nov 11 11:01:35
Subject: Opening for MIS - VBA/SQL
To:
 The sender of this email is registered with Naukri.com as Absolute HR
Solutions Pvt. Ltd.

*Experience required for the Job:* 2 - 7 years
*Annual Salary of the Job:* 0.0 - 4.0 Lacs
*Job Location:* Chennai

*Dear Candidate,*

Dear Candidate,
Urgent Opening with Infosys BPO:

Responsibilities  Activities Description:
Also please fill up the following details -

Candidates are expected to be proactive, communicate effectively across
levels and drive initiatives independently. SHE/HE will

* Participate in business requirements discussions with the different
operations teams
* Document business requirements
* VBA (Visual Basics for Applications) -
Excel/Access-based VB Script apps, Outlook macros or mainframe macros based
on the business requirements
* Testing of macros and other tools
* Provide support on operations floors once tools are deployed
Skills:
* Good understanding of VBA / Excel Macros  VB Scripts.
* Good Understanding of client-server architecture.
* Good Analytical Skills
* Good Written Communication Skills
* Good Knowledge in MIS
* Knowledge on Dot-Net would be an added advantage..

*Qualification -
*EXP-
*Revalent EXP-
* Current CTC - (Fixed) (Variable)___
* Expected CTC -
* Notice Period -
* Passport Status -
*Experience-
*Relevant Experience-
* Why are you looking for a change from the current company? -

Kindly mail me your updated resume with the acceptance of applying for this
role at the earliest feasible. Email Id - praja...@absolutehrs.com

Thanks  Regards,
Prajakti Shende
Management Trainee
Absolute HR International
USA. CANADA. INDIA
www.absolutehrs.com
'Leadership Through Delivery

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ converting excel file into xml file

Hi Vijay,

Try File Save as a .XML

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Fri, Nov 18, 2011 at 9:53 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Dear Gurus,

 Is there any method to convert Excel file into XML format.In some specific
 software for impotring data .the data should be in xml format only,then
 only we can import the data.I need any macro method or any thing  which
 converts excel data into XML FILE FORMAT

 Thanking you all ,

 Regards.
 Vijaykumar













 --
 FORUM RULES (934+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Deleting modules

Hi Chandra Sekar,

Right Click on Module and Remove module and Click option No,,

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar 
chandrashekarb@gmail.com wrote:

 Hello,

 Could you please let me know how to delete module?

 Thanks in advance.



 Regards,

 Chandra Shekar B

 --
 FORUM RULES (934+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Indirect formula

Hi Sumitha,

Please See below links for Indirect  Function More Clarification...
http://www.contextures.com/xlFunctions05.html
http://www.cpearson.com/excel/indirect.htm


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*



On Tue, Nov 15, 2011 at 12:13 PM, smitha.kumari smitha.kum...@speridian.com
 wrote:

  Hi,

 ** **

 Any one please explain why these quotes are used in this formula

 ** **

 =SUMIF(INDIRECT('B$5'!A:A),$A6,INDIRECT('B$5'!I:I))

 ** **

 Regards

 Smitha 

 ** **

 --
 FORUM RULES (934+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Hi Hanumant,

First one you have copied data from Some other Application(New Window
workbook,World..Etc) window and 2nd one Copied
from Same window same sheet's That's what it's Showing different Options...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde arsfan2...@yahoo.co.inwrote:

 Hi Friends,

 i have attached screenshot which has 2 windows for paste special
 functionality.
 i wanted to paste only formula but i got 1st window (Left from reader)
 hence could not do so. can somebody please tell me in what circumstances
 which window appears.
 i.e. which window will open when

 --
 FORUM RULES (934+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Kindly Help

Hi Vijay,


See attached if helps...


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*


On Thu, Nov 17, 2011 at 2:24 PM, vijayKumar midearfam...@gmail.com wrote:

 Dear Friends,

 Request you to help me on a Query of Open Office Excel.

 The Query is as fallows.


1. Can we protect the sheet as we do protect worksheet in XL.
2. Request you to help me in creating a macro to consolidate 40
files(Open Office Excel) in a XL sheet(2007).
3. All Heading of The Files to be consolidated are same but number of
lines may vary.

 Problems faced while doing the same manually is :
 When we copy the data from Open excel and paste to XL-2007 some data will
 be missing which will be in text. but the same will not happen when we copy
 the data from Open excel and paste it in notepad and copy the same from
 notepad to XL-2007.

 --
 Vijay
 998070

 --
 Vijay

 --
 FORUM RULES (934+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


calc6_EN.pdf
Description: Adobe PDF document

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread Venkat CV

Hi,

Refer Below Links..

http://www.cpearson.com/Excel/MainPage.aspx
http://www.teachexcel.com/
http://www.ozgrid.com/VBA/
http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*



On Sun, Oct 16, 2011 at 5:53 AM, Mr excel excelkeec...@gmail.com wrote:

 Hi group,

i would like to know a specific method for learning Excel vba.I mean i m
 just getting perplexed  worried about how to learn excel vba on seeing this
 so many examples in this forum.I could not get a right point where to start
 in vba.

 Kindly suggest some tips or methods so that i can follow in learning excel
 vba.

 Thanks in advance.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread Venkat CV

Dear Ayush,

Congrats

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Group,

 Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
 for the 2nd year in row...

 Congrate Ayush
 --
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-01 Thread Venkat CV

Hi Noorain,

Congrats

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:

 Hello Everyone,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month of
 Sept'11
 He has posted 140 posts in sept 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum but has
 acheived this recognition for first time.

 *About Noorain Ansari :*
 [image: noorain.jpg]

 Noorain is a great poet and keep sharing his thoughts on different topics
 throgh cool poems. Professionally, he is a Excel aficionado and presently
 working as senior business analyst in One97 Communication Ltd. He is a MS
 excel - vba expert and keep sharing his thoughts with this forum. You can
 follow his blogs for Excel knowledge and cool poems :
 www.excel-macro.blogspot.com  www.noorain-ansari.blogspot.com

 *Noorain, Many thanks for all your great support to group. Keep it up*

 *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
 Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
 !!

 *Keep posting.

 Regards
 Ayush Jain
 Group Manager

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
noorain.jpg

$$Excel-Macros$$ Fwd: Job

2011-09-12 Thread Venkat CV

- Original message 
From:S Suvarna ssuva...@magna.in 
Date: 12 Sep 11 13:12:37
Subject: Urgent Oening for SQL Server Developer at Chennai based Client
To: S Suvarna

  Hi,

Greetings for the day!!!

Let me take this opportunity to introduce Magna Infotech Pvt. Ltd. We are
one ofthe most dynamic and fast growing IT Staffing, Development and
SolutionsCompany in India. Spread across 7 Different locations Magna always
responded tothe ever-changing business dynamics  stood the test of time for
the lastten years in India, US. Today we are one of the top 3 IT consulting
andTechnical Staffing Organization in India. Aiming high to scale dizzier
heights.We at Magna Infotech are looking for aggressive and focused
individuals to comeand join us in our Journey of Success  I think you fit
the bill. We havean opening in our organization, which is just right for
you. It is a permanentEmployment with Magna Infotech and you will be working
for our client, for moreinformation on our organization feel free to log on
to www.magna.in. I am sure we willmeet your expectations and together we
will move towards a magnificent future.

We have an urgent requirement for our Chennai  based Client forSQL Server
Developer
Role: SQL Server Developer
Work Location: Chennai  Joining Date: ASAP

Job Description:Skills Required:*Experience on SQL Server/MS SQL*Experience
on .NET*Salary will offer-upto 3 LPA Note: If you are not interested. I
would appreciate if youcan refer some of your friends who are looking out
for a change.
1. Full Name
2. Alternate Num:
3. Land Line num:
4. Present salary:
5. Expected:
6. DOB:
7. Total work experience:
8. Are you ready for interviews?
9. Current location:
10. Notice Period(Preferred asap)
11. Are you a Graduate?
12.Are you fine to work on Magna Infotech Payroll? Best Regards, Suvarna –
Magna infotechssuva...@magna.in Go GreenP Save ATree! Please do not print
this email/attachments unless you really need to.

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
attachment: image001.png

$$Excel-Macros$$ Re: Walk in For Finance Professionals on September 13th and 14thTuesday and Wednesday@ Scope International Haddows Road

2011-09-12 Thread Venkat CV

 - Original message 
 From:Scope International Pvt Ltd ramya.rampra...@sc.com 
 Date: 12 Sep 11 16:01:05
 Subject: Walk in For Finance Professionals on September 13th and
 14thTuesday and Wednesday@ Scope International Haddows Road
 To:

 The sender of this email is registered with Naukri.com as Scope
 International Pvt Ltd Experience required for the Job: 2 - 7 yearsJob
 Location: Chennai
 Dear Candidate,Dear Candidate,

 Greetings from Scope International!!!

 Exciting opportunity with Scope International, (subsidiary of Standard
 Chartered Bank), Chennai for Financial Profesionals.

 Walk in on Tuesday and Wednesday - September 13th and 14th

 Experience: 2 yrs

 Work Location : Chennai

 No Night shift

 Walk in with 2 copies of resumes and 2 passport size photo at our Haddows
 road Office in nungambakkam from 10 Am to 2 Pm.

 We welcome references

 * Good Communication is mandatory

 * Knowledge in Excel

 * Hands on Experience in MIS ,Budgeting, Forecasting,

 Contact Person: Ramya Ramprabhu

 Regards,

 Recruitment TeamIs this job relevant to you? Yes No Your feedback would
 help us in sending you the most relevant job opportunities Disclaimer: The
 sender of this email is registered with naukri.com as Scope International
 Pvt Ltd (satish.xav...@sc.com, 1,Haddows Road, CHENNAI, Tamilnadu -
 66) using Naukri.com services. The responsibility of checking the
 authenticity of offers/correspondence lies with you.

 If you consider the content of this email inappropriate or spam, you
 may:Report abuse by forwarding this email to: compliance@naukri.comYou can
 also Block this Company from searching your resume in the database.
 Advisory: Please do not pay any money to anyone who promises to find you a
 job. This could be in the form of a registration fee, or document processing
 fee or visa charges or any other pretext. The money could be asked for
 upfront or it could be asked after trust has been built after some
 correspondence has been exchanged. Also please note that in case you get a
 job offer or a letter of intent without having been through an interview
 process it is probably a scam and you should contact compliance@naukri.comfor 
 advise. To be on the top of Employer's Resume Search
 Update Your Resume Now Your Resume has only 30 seconds to impress a
 Recruiter. Get your resume written by Experts.
 Call 1800-102-5557 now! (Toll-Free)

 --
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ calculating age with months

2011-09-10 Thread Venkat CV

Hi Sunny,


What ..Result not.

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

On Fri, Sep 9, 2011 at 9:54 PM, XLS S xlst...@gmail.com wrote:

 Great!!! But Result not.


 On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV venkat1@gmail.com wrote:

 Hi Varun,

 See if Helps Attached...

 *Best Regards,*
 *Venkat *
 *Chennai*
 *My Linked in profilehttp://in.linkedin.com/pub/venkatesan-c/21/492/a71
 *



 On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:



 Can any body guide me the formula to calculate the Age in excel with
 months and days.

 Regards

 Varun Chawla

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *
 *
 *
 *
 *
 *


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 .


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Fwd:Job Process Developer

2011-09-10 Thread Venkat CV

- Original message 
From:HR Axis India Pvt Ltd. quali...@hraxisindia.com 
Date: 9 Sep 11 18:01:48
Subject: A Leading MNC Captive BPO Company is looking for Process Developer
(Billing  Collections - US Healthcare) for Hyderabad Location.
To:

The sender of this email is registered with Naukri.com as HR Axis India Pvt
Ltd. Job Location: Hyderabad
Dear Candidate,Warm Greetings from HR AXIS INDIA PVT LTD!!!

A Leading MNC Captive BPO Company is looking for Process Developer (Billing
 Collections - US Healthcare) for Hyderabad Location.

Detailed Job Description: HR Axis India Pvt Ltd is a leading HR Consultancy
in Hyderabad. We are looking for excellent candidates for the following
position with one of our esteemed clients.

About Company: It is a Global Leader in Business Process and Technology
Management. Its entire organization of over 43,300 employees is focused on
process and engaged in improving client processes and driving business
impact. They look at process as a science and their proprietary Smart
Enterprise Process (SEP) employs a scientific, highly granular approach to
managing business process

Services are seamlessly delivered from a global network of centers in 13
countries to meet a clientâ€™s business objectives, cultural and language
needs, and cost reduction strategy. The company became independent in
January 2005, bringing process strength to companies, and was successfully
listed on the NYSE in August 2007. Today the company manages over 3,000
processes for more than 400 clients worldwide.

Job Profile:

Position: Process Developer

Process: Billing  Collections (US Healthcare)

Location: Hyderabad

Skill Set:

ïƒ˜Any Graduate (Non tech graduate)

ïƒ˜Experience of RCM in US health care industry

ïƒ˜ Good verbal and written communication skills

ïƒ˜Understanding of US healthcare billing forms  procedures

ïƒ˜Responsible for communciating with the business (email/call); B2B
collections

ïƒ˜Understanding of Explanation of Benefits

ïƒ˜Good excel  MS Word skills/knowledge / Open to change, new ideas, etc

ïƒ˜Experience of denials managemnet in heathcare RCM

Note: If you are a B.Tech Graduate,then please Ignore this mail.

If you are looking for an excellent change to a world class organization
please send your updated CV to quali...@hraxisindia.com [quality1 at
hraxisindia.com] along with Current CTC, Expected CTC and Notice Period.

-- 

Thanks  Regards

I.Swathi

HR-Executive

Hexa Resource Axis India Pvt Ltd

102, My Home Lakshmi Nivas

Opp Hotel Green Park

Ameerpet,Hyderabad- 500016

Tel: 040-30166019

(M):7396463215

E mail: quali...@hraxisindia.com

URL: www.hraxisindia.com

Note: We do not charge anything from the candidate.Is this job relevant to
you? Yes No Your feedback would help us in sending you the most relevant job
opportunities Disclaimer: The sender of this email is registered with
naukri.com as HR Axis India Pvt Ltd. (sudar...@hraxisindia.com, 102,My Home
Laxmi Nivas, Opp. Hotel Green Park Hotel, Ameerpet, HYDERABAD, Andhra
Pradesh - 500016) using Naukri.com services. The responsibility of checking
the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Fwd: Job MIS Executive at Chennai

2011-09-10 Thread Venkat CV

- Original message 
From:Source One Management Services Pvt.Ltd vik...@msourceone.com 
Date: 10 Sep 11 12:29:14
Subject: Hi, Urgent Opening for MIS Executive at Chennai :Contract to Hire
To:

The sender of this email is registered with Naukri.com as Source One
Management Services Pvt.Ltd Dear Candidate,Hi !

Hope you are doing well !!

This is Vikram from SourceOne. Source One (www.msourceone.com) one of the
fastest growing company from India needs MIS Executives for Chennai location
for One of the leading MNC 2 years of experience

JD â€“

Good in MS Office(Excel and MS word)

Good Communication skills

Only those candidates who can join us in 10days notice period after offer,
should apply.

Your employment with Source One would be permanent after selection and would
be

deputed at multi b$ MNC for a long term project. Salary and long term career
opportunity

with Source One would be excellent.

Kindly send your updated CV with below input if you would be interested for
this opportunity.

Your Contact Number:

Present Company Name location:

Total Exp :

Date of Birth:

Are you working at present (Y/N):

If not please specify reason for not working:

Present Employment (Permanent or Contract):

Current Salary:

Expected minimum salary:

What is your current Notice Period:

Willing to join Source One in 7-10 Days or Immediate, please specify:

Please specify your reason for change:

Willing to work in Chennai

Thanks  Regards,

_

Vikram Anand Sharma

Source One Management Services Pvt Ltd,

E-Mail:vik...@msourceone.com;

URL : www.msourceone.com, www.sourceone.co.inIs this job relevant to you?
Yes No Your feedback would help us in sending you the most relevant job
opportunities Disclaimer: The sender of this email is registered with
naukri.com as Source One Management Services Pvt.Ltd (c...@msourceone.com, *,
BANGALORE, Karnataka - 560001) using Naukri.com services. The responsibility
of checking the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

*Hi,*
*
*
*Please attach some Data in Excel...*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa zakk.co...@gmail.com wrote:

 Hi all,

 I'm trying to build an Excel solution that would do the following:

 - User select a given spreadsheet/worksheet/column(sample below),
 where file location may vary and exchange rate column will vary (based
 on Month)

 - Allows target selection:
   User selects target spreadsheet(s) and worksheet(s) within
 spreadsheet(s)
   User selects currency and amount columns for each worksheet/
 spreadsheet
   User defines target rates (CAD and USD) into target columns
 (e.g. CAD @ G, USD @ I)

 Logic converts values and writes to target columns


 Currency Name   Currency Code   Base Rate   Nov10   Dec10   Jan11
 UNITED STATES DOLLARS   USD CAD 1.0261150.997437
  1.001006
 ALGERIA DINARS  DZD CAD 0.0137640.0133830.013726
 ALGERIA DINARS  DZD USD 0.0134140.0134170.013712
 ARGENTINA PESOS ARS CAD 0.2579470.2512440.249783
 ARGENTINA PESOS ARS USD 0.2513830.2518890.249532
 ARUBA GUILDERS  AWG CAD 0.5732490.5572270.559221
 ARUBA GUILDERS  AWG USD 0.5586590.5586590.558659
 AUSTRALIA DOLLARS   AUD CAD 0.9844331.019336
  0.997949
 AUSTRALIA DOLLARS   AUD USD 0.9593791.021956
  0.996946
 BAHAMAS DOLLARS BSD CAD 1.0261150.9974371.001006
 BAHAMAS DOLLARS BSD USD 1.001.001.00
 BAHRAIN DINARS  BHD CAD 2.7214652.6451602.655154
 BAHRAIN DINARS  BHD USD 2.6522032.6519572.652485
 BANGLADESH TAKA BDT CAD 0.0145860.0141180.014139


 Can you help?

 Thanks in advance!

 JC

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Report Generation

Hi ,

See Below links if Helps...

http://databases.about.com/od/tutorials/l/aareports1.htm
http://office.microsoft.com/en-us/access-help/create-a-simple-report-HA001230739.aspx
http://www.databasedev.co.uk/reports.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Fri, Sep 9, 2011 at 11:45 AM, Kishan Reddy, K 
kishanreddy.kethire...@gmail.com wrote:

 Try Ms-Access.
 Put your data in a table and try the report wizard, which will guide
 you.

 If you still want the report in excel itself, it can be done using VBA
 coding.

 Send a sample file so that best approach can be decided based upon the
 quantity of data and compelxity of the report.


 Regards,
 Kishan Reddy, K


 On Sep 8, 9:37 am, Shankar Bheema shankar.n...@gmail.com wrote:
  What is the procedure to develop reports basing on the excel database
  through UserForm.
 
  Report generation in the sense, not in column and rows.
 
  It would be look like a form in word document.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Msg Box

Hi,

Look Attached...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent suryaprasad...@gmail.comwrote:

 Hi Group,

 I have a form which has a Close button and a Code assgined to it as below:

 Private Sub cmdClose_Click()
 MsgBox Do you want to Save the details, vbYesNoCancel
 Unload Me
 End Sub

 But What i need is when i Click on OK button on the form should close or
 if i click on No the Form should not close and If i click on Cancel then
 the Msg box shud be disappeared.

 Attached is the sheet

 Please help

 Thanks
 Prasad.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Close.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Hi  Jose,

Just go to your Gmail and Compose Mail and send it to *
excel-macros@googlegroups.com * and it will Automatically Reach Group.. You
can attach your file in Gmail itself..



On Fri, Sep 9, 2011 at 6:15 PM, Jose Costa zakk.co...@gmail.com wrote:

 Hi Venkat,

 Thanks for your quick reply.

 I'm new to the group and couldn't find any option to attach files.

 Jose


 On Sep 9, 3:15 am, Venkat CV venkat1@gmail.com wrote:
  *Hi,*
  *
  *
  *Please attach some Data in Excel...*
  *
  *
  *Best Regards,*
  *Venkat *
  *Chennai*
  *My Linked in profile 
 http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
 
 
 
 
 
  On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa zakk.co...@gmail.com wrote:
   Hi all,
 
   I'm trying to build an Excel solution that would do the following:
 
   - User select a given spreadsheet/worksheet/column(sample below),
   where file location may vary and exchange rate column will vary (based
   on Month)
 
   - Allows target selection:
 User selects target spreadsheet(s) and worksheet(s) within
   spreadsheet(s)
 User selects currency and amount columns for each worksheet/
   spreadsheet
 User defines target rates (CAD and USD) into target columns
   (e.g. CAD @ G, USD @ I)
 
   Logic converts values and writes to target columns
 
   Currency Name   Currency Code   Base Rate   Nov10   Dec10   Jan11
   UNITED STATES DOLLARS   USD CAD 1.0261150.997437
1.001006
   ALGERIA DINARS  DZD CAD 0.0137640.013383
  0.013726
   ALGERIA DINARS  DZD USD 0.0134140.013417
  0.013712
   ARGENTINA PESOS ARS CAD 0.2579470.251244
  0.249783
   ARGENTINA PESOS ARS USD 0.2513830.251889
  0.249532
   ARUBA GUILDERS  AWG CAD 0.5732490.557227
  0.559221
   ARUBA GUILDERS  AWG USD 0.5586590.558659
  0.558659
   AUSTRALIA DOLLARS   AUD CAD 0.9844331.019336
0.997949
   AUSTRALIA DOLLARS   AUD USD 0.9593791.021956
0.996946
   BAHAMAS DOLLARS BSD CAD 1.0261150.997437
  1.001006
   BAHAMAS DOLLARS BSD USD 1.001.00
  1.00
   BAHRAIN DINARS  BHD CAD 2.7214652.645160
  2.655154
   BAHRAIN DINARS  BHD USD 2.6522032.651957
  2.652485
   BANGLADESH TAKA BDT CAD 0.0145860.014118
  0.014139
 
   Can you help?
 
   Thanks in advance!
 
   JC
 
   --
 
  
 ------
   Some important links for excel users:
   1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
   2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
   3. Excel tutorials athttp://www.excel-macros.blogspot.com
   4. Learn VBA Macros athttp://www.quickvba.blogspot.com
   5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 
   To post to this group, send email to excel-macros@googlegroups.com
 
   
   Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 
  --
  *
  *
  *
  *
  *
  *- Hide quoted text -
 
  - Show quoted text -

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to recast a variant as an array in VBA

Hi,

See below links..

http://www.mrexcel.com/forum/showthread.php?t=32187
http://www.ozgrid.com/forum/showthread.php?t=69235page=1
http://www.cpearson.com/excel/vbaarrays.htm

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Wed, Sep 7, 2011 at 3:56 PM, ShayneH shayne.hus...@gmail.com wrote:

 Is there a way to expose an array that is enclosed by a variant?
 Basically I have one function that returns a variant type which needs
 to be passed to another procedure that requires the parameter to be
 typed as a byte array.

 eg:
 Function UsuallyReturnsAnArray() As Variant

 the result, after testing to be an array is passed to:

 Sub ConsumesByteArray(ByRef ByteArray() As Byte)

 I need to find a way to coerce the variant that contains a byte array
 returned from the first function to a byte array.
 Copying each element to a dimensioned array is a possible solution,
 but it seems to me there must be a way to reference the array that is
 contained inside the variant type.

 Thanks in advance

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

Hi ,

See Below Links...
http://www.contextures.com/xlcondformat03.html\
http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Wed, Sep 7, 2011 at 1:30 PM, zp18 irvinep...@gmail.com wrote:

 A1=the name of an employee, defined name is Suspect
 A2= an amount of money, defined as MaxLoss
 B1:B8 is a column of money defined as Shortages
 C1:G8 is a range of employee names defined as Associates


 if the money contained in MaxLoss is less than the amount in column of
 Shortages and the Suspect's name is contained in the Associates
 range then do something(bold, red, flashing etc)


 The intent is to match an employees name to shortages using
 conditional formatting

 James$57.20 Grace   Ronnie  MernalynIrene   0
 -50  $4.91  Julie   Jocelyn Tiffany
 RyanMark
 $22.50 Grace   Ronnie  James   Irene   Mernalyn
 $(0.78)Julie   Tiffany RyanMark
0
 $50.06 Grace   James   MernalynIrene   0
 $2.65  Julie   Tiffany RyanMark0
 $24.28 Grace   0  00
 0
 $(373.20)  Julie   Jocelyn Ryan0
 0

 What should the statement be?  I cannot get the hang of logical
 operators in conditional formatting, any help would be appreciated.

 TIA

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ reference auto copy in shee2

Hi Sanjib,

You Can try Advanced filter Option in 2007

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee 
chatterjee.kolk...@gmail.com wrote:

  Good Morning Everybody,

 I want to create a macro to copy the selected data from sheets1 to sheet2
 automatically
 after pressing a shortcut key.
 Please help who to do that.
 Waiting for your reply.

 Thank you in Advance

 Sanjib Chatterjee

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Hi Bheema,

See below image and Try Data Validation and use custom and formula as *
=COUNTIF(C:C,C1)=1*

[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar shankar.n...@gmail.comwrote:

 I made a userform. linked it with the datasheet.  the filenumber acts
 as a bridge between userform and datasheet.  I have to make the file
 number unique in excel. Because the duplicate numbers also accepting
 by the datasheet.  If it happened so, my intention will not fulfill.
 So kindly provide solution to make the filenumber column of the
 datasheet as unique.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
image.png

Re: $$Excel-Macros$$ Crystal Reports for vba excel

Hi ,

See below links if Helps

http://forums.esri.com/Thread.asp?c=93f=992t=67019
http://www.codeguru.com/forum/showthread.php?t=356836

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Fri, Sep 9, 2011 at 10:42 AM, Shankar Bheema shankar.n...@gmail.comwrote:

 Good morning to all,

 Is the crystal report software which will use for report generation in
 Visual Basic 6 will work with VBA Excel ?  If so, I request to you all,
 provide me sample project to understand.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Hi

2011-09-06 Thread Venkat CV

Hi Mudit,

See Below Links

http://www.excel-vba.com/
http://www.ozgrid.com/VBA/
http://www.exceltip.com/book-1931841047.html
http://www.cpearson.com/excel/Downloads.aspx
http://www.contextures.com/tiptech.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Tue, Sep 6, 2011 at 11:37 AM, Mudit Gandhi forumu...@gmail.com wrote:

 Please help me.

 On Tue, Sep 6, 2011 at 10:37 AM, Mudit Gandhi forumu...@gmail.com wrote:

 Hi group

 I am beginner at macro so i want a pdf tutorials in which i could get all
 the formulaes used in macro with examples.

 Thanks for ur help
 Mudit


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Fwd: mis executive, chennai, CONTRACT 2 HIRE

2011-09-05 Thread Venkat CV

- Original message 
From:Source One Management Services Pvt.Ltd farhee...@msourceone.com 
Date: 5 Sep 11 12:33:34
Subject: mis executive, chennai, CONTRACT 2 HIRE
To:

The sender of this email is registered with Naukri.com as Source One
Management Services Pvt.Ltd Dear Candidate,Hi !

Hope you are doing well !!

This is Farheeen from SourceOne. Source One (www.msourceone.com) one of the
fastest growing

company from India needs many candidates on mis

location: chennai with 3-6 years of experience

Only those candidates who can join us in 10days notice period after offer,
should apply.

Your employment with Source One would be permanent after selection and would
be

deputed at multi b$ MNC for a long term project. Salary and long term career
opportunity

with Source One would be excellent.

Kindly send your updated CV with below input if you would be interested for
this

opportunity.

Your Contact Number:

Present Company Name location:

Total Exp :

Date of Birth:

Are you working at present (Y/N):

If not please specify reason for not working:

Present Employment (Permanent or Contract):

Current Salary:

Expected minimum salary:

What is your current Notice Period:

Willing to join Source One in 7-10 Days or Immediate, please specify:

Please specify your reason for change:

Willing to relocate.

Thanks  Regards,

_

Farheen S

Source One Management Services Pvt Ltd,

E-Mail:farhee...@msourceone.com;

URL : www.msourceone.com, www.sourceone.co.inIs this job relevant to you?
Yes No Your feedback would help us in sending you the most relevant job
opportunities Disclaimer: The sender of this email is registered with
naukri.com as Source One Management Services Pvt.Ltd (f...@msourceone.com, *,
BANGALORE, Karnataka - 560001) using Naukri.com services. The responsibility
of checking the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

Dear *venkat1.sql!* Get Yourself a cool, short *@in.com* Email ID
now!http://mail.in.com/mails/new_reg.php?utm_source=inviteutm_medium=outgoing

-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

2011-09-05 Thread Venkat CV

Congratulations

Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone...


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote:

 Hello Everyone,
 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 August'11
 He has posted 152 posts in August 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and has
 acheived this recognition for second time consecutively.

 Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for
 helping excel enthusiasts voluntarily !! Keep it up !!

 Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

2011-09-03 Thread Venkat CV

Hello Haeruddin,

Please send your Query..


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Sat, Sep 3, 2011 at 3:53 AM, Udin Haeruddin herumam...@gmail.com wrote:

 --
 == Haeruddin, S.Pd ==

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Query

2011-09-03 Thread Venkat CV

Dear Shasi,

You are Welcome...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan shashi2...@gmail.com wrote:

 Dear Venkat  Noorain Sir

 I am very thankful to you for sharing your precipus time helping me solve
 this task.

 Thanks  Regards
 Shashi Ranjan



 On 1 September 2011 15:09, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Shashi,

 Please see attached sheet if it help to u...

 On Thu, Sep 1, 2011 at 2:22 PM, shashi shashi2...@gmail.com wrote:

 Dear Venkat

 I have second condtion that i want payout amount datewise. I want an
 urgent help on condition function. In this data i have the requirement
 of *Payout amount* for each branch in datewise without using

 On Aug 31, 10:15 pm, shashi shashi2...@gmail.com wrote:
  Dear Excel Guru's
 
  I want an urgent help on condition function. In this data i have the
  requirement of *Payout amount* for each branch in datewise without
 using
  pivot. Please help me in this query.
 
  Thanks
  Regards
  Shashi Ranjan
 
   Consolidation RI payout Data.xls
  1512KViewDownload

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Thanks  regards,
 Noorain Ansari
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Vlookup with more than one condition

2011-09-02 Thread Venkat CV

Dear Haytham,

Try SUMPRODUCT...


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba haythamzoro...@gmail.comwrote:

 Dear all,

 I have tried to search about using vlookup with more than one condition.

 Is their any one know a formula for that?


 BRegards,
 Haytham Zoromba

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Vlookup with more than one condition

2011-09-02 Thread Venkat CV

Dear Haytham,

See sample...If Helps..

 *Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*



On Fri, Sep 2, 2011 at 7:07 PM, Venkat CV venkat1@gmail.com wrote:

 Dear Haytham,

 Try SUMPRODUCT...


 *Best Regards,*
 *Venkat *
 *Chennai*
 *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71
 *

   On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba 
 haythamzoro...@gmail.com wrote:

 Dear all,

 I have tried to search about using vlookup with more than one condition.

 Is their any one know a formula for that?


 BRegards,
 Haytham Zoromba

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *
 *
 *
 *





-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Book2 query(venkat).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ write and read cookies through vba.

2011-09-02 Thread Venkat CV

Hi ,

Look Below links...

http://www.java2s.com/Code/ASP/Session-Cookie/WriteCookieandreadCookieVBnet.htm

http://www.bigresource.com/VB-Read-Cookie-in-VBA-from-Word-QVYNPHx6U0.html
-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Fri, Sep 2, 2011 at 4:12 PM, Divaker Pandey divake...@gmail.com wrote:

 Hi Expert.

 Is there any way to write and read cookies through vba.

 Thanks in advance.

 Divaker

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ extracting data from a datasheet

2011-09-01 Thread Venkat CV

Hi

Please attach sample data

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar shankar.n...@gmail.comwrote:

 I made an userform with Empno, Name, Design, DOB textboxes with the
 save command. I am able to save the data. Now, I need code for
 updating the already contained data in a datasheet.

 How to retrieve data from datasheet basing the Empno and update
 (command button).  Pls provide code.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ stock on hand report generate

Hi Jasmin,

Share some sample data...

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 10:27 PM, jasmin snband...@gmail.com wrote:

 Hi all experts

 i have a small store which contains 300 products( MEDICINES).in a
 quarter i reviced the items once or twice.But i issue items to various
 dept twice in a week or thrice in fortnight.My requirement is

 1.on item recieved to my store i enter all items in reciept colum.The
 qty should add the previous balance
 2. if i issue the qty should deduct.

 3 on end of the month stock on hand report shoud generte to print ( if
 it possibe with expiry date).

 Please help me in excel is it possibel with vba code Like Reciepts,
 Issues,Reports, Departments(to select which i issue) user form. and
 data management information .


 thanks in advance

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003

Hi Rajan,

Nice Array formula  Sumproduct superb solution...

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 10:34 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  *See the attached *

 * *

 * *

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
 *Sent:* Wednesday, August 31, 2011 7:33 AM

 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Option for countifs  Sumifs formula in MS
 Excel 2003

  ** **

 Hi Amit

 ** **

 See below link for Sumifs in 2003

 http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 

 ** **

 -- 

 *Best Regards,*

 *Venkat *

 *Chennai*

 ** **

 ** **

 On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) 
 amit.de...@merucabs.com wrote:

 Dear All,

  

 Do we have any option for countifs  Sumifs formula in MS Excel 2003?

  

 Best Regards,

 Amit Desai

  

 ** **
  --

 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel



 

 ** **

 ** **

 ** **

 ** **

 ** **

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ job

-- Original message --

From:Teamware Solutions (quantum leap consulting) sw...@twsol.com 
Date: 30 Aug 11 12:43:07
Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS,
Kochi
To:

 The sender of this email is registered with Naukri.com as Teamware
Solutions (quantum leap consulting)

*Experience required for the Job:* 4 - 8 years
*Job Location:* Ernakulam / Kochi / Cochin

*Dear Candidate,*

Warm Greetings!!

We are Teamware Solutions, a professional IT services company head quartered
in Bangalore. Teamware is a division of Quantum Leap Consulting Pvt. Ltd.
and we specialize in contract staffing, placements and executive search. Our
clientele include some of the best names in the IT industry worldwide like
HP, Accenture, Deloitte, Cap Gemini, EDS, TCS, ATOS, to name a few.

Our offices in Bangalore, Chennai and Mumbai look after our client's
domestic requirements and our Singapore outfit, Teamware Solutions Pte Ltd.
takes care of requirements in the Asia-pacific region.

The choice of clients and our presence in national and international market
can assure you of our commitment in providing you the best of opportunities
and ending your search for a dream job.

Mandatory Skill: MS SQL server 2005/2008

Exp Level: 4+ Yrs

Location: Kochi

Client :  TCS

Note: Candidates who can join within short notice period  (10-14 days) from
the date of selection need to apply for this position.

Also mention the details given below.

Willingness to work on the direct payrolls of Teamware Solutions- Yes/No
Total Experience:
Relevant Experience:
Current CTC:
Expected CTC:
NTC:
Official Mail:
Date of Birth-
Educational Details-(Mention if regular or Correspondence):
Current Company:
Current Location:
Preferred Location:

If this mail is irrelevant to you kindly oblige and Ignore this Mail

Thanking You

Wishing you a nice day ahead !!!

Warm Regards,

Thanks  regards
Swati
Teamware Solution
201-203, First Floor , Oxford Chambers, Rustambagh Road
Off: Airport Road, Bangalore-560017
email-sw...@twsol.com
office-08040818510
website:www.teamwaresolutions.net

Is this job relevant to you?
Yeshttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=yesmid=3822059
Nohttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=nomid=3822059
 Your
feedback would help us in sending you the most relevant job opportunities
Disclaimer:
The sender of this email is registered with naukri.com as *Teamware
Solutions (quantum leap consulting)* (ad...@twsol.com, 305, 2nd Floor,
Oxford House Rustum Baugh, OFF OLD AIRPORT ROAD BANGALORE, BANGALORE,
Karnataka - 560017) using Naukri.com services. The responsibility of
checking the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you may:

   1. Report abuse by forwarding this email t o: complia...@naukri.com
   2. You can also Block this
Companyhttp://my.naukri.com/BlockCompany/edit/cid/4793from searching
your resume in the database.

Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise.
   *To be on the top of Employer's Resume Search
Update Your Resume Nowhttp://www.naukri.com/tieups/tieups.php?othersrcp=4794
*   *Your Resume has only 30 seconds to impress a Recruiter. Get your resume
written by 
Experts.http://resume.naukri.com/resume-writing-services?fftid=73
Call 1800-102-5557 now! (Toll-Free)*

-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Guru's Pls reply me

Hi Kannan,

Look attached used formulas...

=COUNTIFS(Sheet1!$B:$B,Sheet3!$A2,Sheet1!$E:$E,Sheet3!H$1)

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Wed, Aug 31, 2011 at 11:02 AM, kannan excel kannan.ex...@gmail.comwrote:

 Sorry guys.


 I don't want pivot table. i want like that any macro or formulas.

 help me

 On Tue, Aug 30, 2011 at 8:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  *Hi*

 *See the attached ,*

 *First we need to create a NameRange and need to put that in Pivot Table
 dataSource ,*

 * *

 *Hope it will helps you.*

 * *

 *Rajan.*

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *kannan excel
 *Sent:* Tuesday, August 30, 2011 6:25 PM
 *To:* Google
 *Subject:* $$Excel-Macros$$ Guru's Pls reply me

 ** **

 Hi Excel Guru's,

  

 PFA

  

 pls help me. i want to report for daily actions. like Activation how much,
 rejection how much and ect...

  

 I want like a pivot table. but if i add any datas in sheet1 means
 automatically sheet 2 reports want to change.

  

 (Sheet 1 is my data, Sheet 2 is my reports) if i delet some row in my
 sheet one means that also automatically want to change in sheet 2.

  

 Regards

  

 V. Kannan.

 Aircel Limited

 Chennai

  

  

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


User(Solved) (1).xlsm
Description: Binary data

Re: $$Excel-Macros$$ Conditional Formatting and Logical Operators

Hi,

See below links if helps..

http://www.cpearson.com/excel/cformatting.htm
http://www.excelforum.com/excel-general/497309-can-logical-operators-be-used-within-conditional-formatting.html

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Wed, Aug 31, 2011 at 11:36 AM, zp18 irvinep...@gmail.com wrote:

Excel 7
I have 60 rows, one for each of two shifts, each day of the month
Each row has 7 columns with an employee name in each column
I have one column (M) with the number of hours worked.

I have a constant field named Associate which contains the name of
one of the employees

Currently I have conditional formatting the will highlight the
employee whose name is contained in the Associate cell

and it the rule looks like this:
Cell value = Associate Format[black, yellow background] Applies to
=$N$30:$T$89

I want to add in the condition of the hours worked column (M) less
than 4.5 in order for the format to be true.

How can I add this condition?

I tried: =AND($N30:$T30=Associate,$M30MinHrs)

Thanks, zp18

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
*
*

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Super Urgent - Thinking beyond

Hi Karan,

Go to Hyperlink and try Exiting file or webpage option and selcect the word
document..

[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*

On Wed, Aug 31, 2011 at 4:24 PM, karan 1237 karan1...@gmail.com wrote:

 Hello Everyone,

 Is there any way to hyperlink a cell to a ms word document but only a
 page


 Kaяan




  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
image.png

Re: $$Excel-Macros$$ Book2.xlsx

Hi Sudhir,

Try this

*=SUMPRODUCT((B3:B7=F5)*(A3:A7=G5)*(C3:C7))*

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote:

 Dear All

 ** **

 Please suggest a formula of Sumproducts

 ** **

 Thanking u

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Book2 query(venkat).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Book2.xlsx