$$Excel-Macros$$ MS excel training company Gurgaon

[Naveen Yadav]

The Greatest Diwali Bumper Discount at Advance Excel Training with SSDN 
Technologies...!!

Microsoft® Excel  Advanced certification training helps you to understand 
how to organize, visualize, calculate & manage data in MS Excel . Learn how 
to create efficient formulas and use some of the 450+ functions in Excel to 
tabulate and analyze numerical, date, and text data. SSDN Technologies is 
Educational institute which offer *MS excel training company Gurgaon* 
using VBA and also provide 
such education and training to students. SSDN Technologies 
 is known for the best advanced excel course, 
dashboards training and VBA institute in Gurgaon. 

SSDN Technologies

0124-4018080 

509970

M 44 & 50, Sector 14 Main Rd, Old DLF Colony, Sector 14

Gurgaon, Haryana 122001

http://www.ssdntech.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$$ MS Excel Training for Microsoft Office Specialist Certification

[letsgolive30]

This* MS Excel 2013  *Course 
has been designed for students, clerical workers, book keepers, and 
instructors, to provide them with a basic knowledge of using the various 
features of Excel. By enrolling for the course, the students can practice 
working on Excel for creating budgets, charts, sales invoices, exercise 
logs, and much more.

For more details Please Contact...
SSDN Technologies
M-44 & M-50,Old-DLF,Sec-14, Gurgaon-122001
0124-4018080, 109937
http://www.ssdntech.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$$ MS Excel

[Sandeep Kumar Chhajer]

I possible please share a sample file.

Thanks & Regards,
Sandeep Kumar Chhajer
Mumbai
India 

Sent on my BlackBerry® from Vodafone

-Original Message-
From: "Soni.Rajender" 
Sender: excel-macros@googlegroups.com
Date: Tue, 10 Dec 2013 23:25:40 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MS Excel



Dear Team
 
I have a bulky database having details of Dealer, item code and Qty, I want 
to make a report that which dealer has not sold which item, please help, 
preferably using pivot table.
 
dealerItemaa1ba2aa3ca4aa5da6

Regards,
Rajender Soni 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

$$Excel-Macros$$ MS Excel

[Soni.Rajender]

Dear Team
 
I have a bulky database having details of Dealer, item code and Qty, I want 
to make a report that which dealer has not sold which item, please help, 
preferably using pivot table.
 
dealerItemaa1ba2aa3ca4aa5da6

Regards,
Rajender Soni 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

$$Excel-Macros$$ MS Excel

[Rajender Soni]

Dear Team

I have a bulky database having details of Dealer, item code and Qty, I want
to make a report that which dealer has not sold which item, please help,
preferably using pivot table.

 dealer Item  a a1  b a2  a a3  c a4  a a5  d a6

Regards,
Rajender Soni

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

Re: $$Excel-Macros$$ MS Excel 2003 to 2010

[xlstime]

Hi Prashant,

Please download Interactive menu to ribbon guide

http://www.microsoft.com/en-us/download/confirmation.aspx?id=16642

.

Enjoy
Team XLS



On Mon, Oct 14, 2013 at 3:21 PM, Prashant Pednekar wrote:

> Dear friends
>
> We are migrating from MS Excel 2003 to Excel 2010
> Dose any one of you has Menu and commond by command comparion in both
> version.s
> i.e. 2003  2010
>  Data > Validation  ???
>
> Else is anyone has related material.
>
> Regards
> Prashant
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010

[Prashant Pednekar]

Good morning all.

Sorry ! I did not used *Please help.*
in my earlier mail.

Request you to help me.
Thanks
Prashant.

-- Forwarded message --
From: Prashant Pednekar 
Date: Mon, Oct 14, 2013 at 3:21 PM
Subject: $$Excel-Macros$$ MS Excel 2003 to 2010
To: excel-macros@googlegroups.com


Dear friends

We are migrating from MS Excel 2003 to Excel 2010
Dose any one of you has Menu and commond by command comparion in both
version.s
i.e. 2003  2010
 Data > Validation  ???

Else is anyone has related material.

Regards
Prashant


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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

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

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

$$Excel-Macros$$ MS Excel 2003 to 2010

[Prashant Pednekar]

Dear friends

We are migrating from MS Excel 2003 to Excel 2010
Dose any one of you has Menu and commond by command comparion in both
version.s
i.e. 2003  2010
 Data > Validation  ???

Else is anyone has related material.

Regards
Prashant

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

$$Excel-Macros$$ MS Excel Password Recovery Software

[riny vangogh]

 

hello

Everyone I tell you my self experience about Excel password 
recoverysoftware, 
a few days ago I have lost my excel file password then I could not remember 
what was my excel file password then I searched an excel file password 
recovery software on Google. Instantly I found a PDS Excel password 
recovery software which helped me to recovered my lost excel file password 
it’s really very amazing excel password recovery software which worked on 
my locked excel file and immediately scan my lost excel file password and 
provides me opportunity to work with again my excel sheet so I would like 
to recommended you that you should use PDS Excel password recovery software 
for your locked excel file.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

Re: $$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

[Richard]

That did it.  I found out the issue (that user had macros disabled) and 
made appropriate changes so it will now run.

On Monday, January 28, 2013 7:25:04 PM UTC-8, David Grugeon wrote:
>
> Hi Richard
>
> I suppose you are trying to say that, although the workbook opens, it does 
> not do whatever the macro should do.  Could this be because it is running 
> in the scheduler's workspace, which does not have access to your workspace. 
>  you may need to get scheduler to run it using either your logon or else 
> gicve the scheduler logon access to all the resources needed.
>
> You probably have set up a user for the Scheduler.  Try logging on as that 
> user and then open the file and test the macro.
>
> Regards
> David Grugeon
>
>
> On 29 January 2013 09:49, Richard >wrote:
>
>> I have a workbook which has a VBA script in the thisworkbook called sub 
>> workbook_open.  When I open the workbook, it runs perfectly, and does 
>> exactly what I want it to do.
>> If I try to schedule it to run at 5PM everyday, Windows Scheduler will 
>> show that the job is running, and I know that the workbook is open because 
>> if I try to open the workbook in Excel I get a message that says that it 
>> can only be opened in read only since it is in use by my login ID on the 
>> scheduler.
>> It eventually is killed by the scheduler when it exceeds the amount of 
>> time allowed (it takes under in minute to process manually, and the timeout 
>> if 10 minutes.  The scheduler log doesn't show any errors except that it 
>> was stopped for exceeding the timeout.
>> Any thoughts would be appreciates.  I have other workbooks that work 
>> perfectly under Excel
>> Thanks in advance,
>> Rich Mogy
>>
>> -- 
>> Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>

-- 
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$$ MS Excel, VBA and Windows Scheduler

[Richard]

Thank you David.  Unfortunately you are right. I say unfortunately because 
I am forced to change my password every 3 months, so having it on my logon 
means one more thing to remember.

Any thoughts on what resources the alternate login, which never changes, is 
looking for

Thanks again

On Monday, January 28, 2013 7:25:04 PM UTC-8, David Grugeon wrote:
>
> Hi Richard
>
> I suppose you are trying to say that, although the workbook opens, it does 
> not do whatever the macro should do.  Could this be because it is running 
> in the scheduler's workspace, which does not have access to your workspace. 
>  you may need to get scheduler to run it using either your logon or else 
> gicve the scheduler logon access to all the resources needed.
>
> You probably have set up a user for the Scheduler.  Try logging on as that 
> user and then open the file and test the macro.
>
> Regards
> David Grugeon
>
>
> On 29 January 2013 09:49, Richard >wrote:
>
>> I have a workbook which has a VBA script in the thisworkbook called sub 
>> workbook_open.  When I open the workbook, it runs perfectly, and does 
>> exactly what I want it to do.
>> If I try to schedule it to run at 5PM everyday, Windows Scheduler will 
>> show that the job is running, and I know that the workbook is open because 
>> if I try to open the workbook in Excel I get a message that says that it 
>> can only be opened in read only since it is in use by my login ID on the 
>> scheduler.
>> It eventually is killed by the scheduler when it exceeds the amount of 
>> time allowed (it takes under in minute to process manually, and the timeout 
>> if 10 minutes.  The scheduler log doesn't show any errors except that it 
>> was stopped for exceeding the timeout.
>> Any thoughts would be appreciates.  I have other workbooks that work 
>> perfectly under Excel
>> Thanks in advance,
>> Rich Mogy
>>
>> -- 
>> Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>

-- 
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$$ MS Excel, VBA and Windows Scheduler

[David Grugeon]

Hi Richard

I suppose you are trying to say that, although the workbook opens, it does
not do whatever the macro should do.  Could this be because it is running
in the scheduler's workspace, which does not have access to your workspace.
 you may need to get scheduler to run it using either your logon or else
gicve the scheduler logon access to all the resources needed.

You probably have set up a user for the Scheduler.  Try logging on as that
user and then open the file and test the macro.

Regards
David Grugeon


On 29 January 2013 09:49, Richard  wrote:

> I have a workbook which has a VBA script in the thisworkbook called sub
> workbook_open.  When I open the workbook, it runs perfectly, and does
> exactly what I want it to do.
> If I try to schedule it to run at 5PM everyday, Windows Scheduler will
> show that the job is running, and I know that the workbook is open because
> if I try to open the workbook in Excel I get a message that says that it
> can only be opened in read only since it is in use by my login ID on the
> scheduler.
> It eventually is killed by the scheduler when it exceeds the amount of
> time allowed (it takes under in minute to process manually, and the timeout
> if 10 minutes.  The scheduler log doesn't show any errors except that it
> was stopped for exceeding the timeout.
> Any thoughts would be appreciates.  I have other workbooks that work
> perfectly under Excel
> Thanks in advance,
> Rich Mogy
>
> --
> 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.
>
>
>

-- 
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.

$$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

[Richard]

I have a workbook which has a VBA script in the thisworkbook called sub 
workbook_open.  When I open the workbook, it runs perfectly, and does 
exactly what I want it to do.
If I try to schedule it to run at 5PM everyday, Windows Scheduler will show 
that the job is running, and I know that the workbook is open because if I 
try to open the workbook in Excel I get a message that says that it can 
only be opened in read only since it is in use by my login ID on the 
scheduler.
It eventually is killed by the scheduler when it exceeds the amount of time 
allowed (it takes under in minute to process manually, and the timeout if 
10 minutes.  The scheduler log doesn't show any errors except that it was 
stopped for exceeding the timeout.
Any thoughts would be appreciates.  I have other workbooks that work 
perfectly under Excel
Thanks in advance,
Rich Mogy

-- 
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$$ MS Excel Vlookup query

[NOORAIN ANSARI]

Dear Vinod,

Please try it..

=OFFSET($O$11,SMALL(IF($L$12:$L$20=$F$13,ROW($O$12:$O$20),""),ROW(A1))-11,0)

with ctrl+shift+enter

See attachment for more clarity.


On Tue, Aug 21, 2012 at 9:49 AM, Kuldeep Singh wrote:

>
> Hi Vinod,
>
> Please See attached file.
>
> Regards,
> Kuldeep Singh
>
>
> On Tue, Aug 21, 2012 at 12:10 AM, vinod rao  wrote:
>
>> thanks Don.
>>
>> I could get the right result. Thanks for your help. Have a nice day.
>>
>> On Tue, Aug 21, 2012 at 12:09 AM, vinod rao wrote:
>>
>>> can i request you to put in the excel file. I am unable to get the
>>> relevelt result
>>>
>>>
>>> On Tue, Aug 21, 2012 at 12:02 AM, dguillett1 wrote:
>>>
>>>>
>>>> =INDEX($L$12:$O$26,SMALL(IF(($F$13=$L$12:$L$26),ROW($L$12:$L$26)-MIN(ROW($L$12:$L$26))+1,""),ROW(A1)),4)
>>>> An array formula that must be entered using ctrl+shift+enter
>>>>
>>>> Don Guillett
>>>> Microsoft Excel Developer
>>>> SalesAid Software
>>>> dguille...@gmail.com
>>>>
>>>>  *From:* vinod rao 
>>>> *Sent:* Monday, August 20, 2012 1:05 PM
>>>> *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ MS Excel Vlookup query
>>>>
>>>>   Hi,
>>>>
>>>> I need a formula plz.
>>>> My data base is very huge. i cannot use autofilter.
>>>>
>>>>  On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 wrote:
>>>>
>>>>>Just use data>filter>autofilter
>>>>>
>>>>> Don Guillett
>>>>> Microsoft Excel Developer
>>>>> SalesAid Software
>>>>> dguille...@gmail.com
>>>>>
>>>>>  *From:* vinod rao 
>>>>> *Sent:* Monday, August 20, 2012 12:35 PM
>>>>> *To:* excel-macros@googlegroups.com
>>>>> *Subject:* $$Excel-Macros$$ MS Excel Vlookup query
>>>>>
>>>>>Hi Team,
>>>>>
>>>>> I want to put vlookup or any other foumula and get the second/third
>>>>> lookup data.
>>>>>
>>>>> See attached file for example. Thanks advance for any help.
>>>>> Regards
>>>>> Vin
>>>>> --
>>>>> 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
>>>>> mailto:excel-macros%2bunsubscr...@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.
>

Re: $$Excel-Macros$$ MS Excel Vlookup query

[vinod rao]

thanks Don.

I could get the right result. Thanks for your help. Have a nice day.

On Tue, Aug 21, 2012 at 12:09 AM, vinod rao  wrote:

> can i request you to put in the excel file. I am unable to get the
> relevelt result
>
>
> On Tue, Aug 21, 2012 at 12:02 AM, dguillett1  wrote:
>
>>
>> =INDEX($L$12:$O$26,SMALL(IF(($F$13=$L$12:$L$26),ROW($L$12:$L$26)-MIN(ROW($L$12:$L$26))+1,""),ROW(A1)),4)
>> An array formula that must be entered using ctrl+shift+enter
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* vinod rao 
>> *Sent:* Monday, August 20, 2012 1:05 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ MS Excel Vlookup query
>>
>>   Hi,
>>
>> I need a formula plz.
>> My data base is very huge. i cannot use autofilter.
>>
>>  On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 wrote:
>>
>>>Just use data>filter>autofilter
>>>
>>> Don Guillett
>>> Microsoft Excel Developer
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* vinod rao 
>>> *Sent:* Monday, August 20, 2012 12:35 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ MS Excel Vlookup query
>>>
>>>Hi Team,
>>>
>>> I want to put vlookup or any other foumula and get the second/third
>>> lookup data.
>>>
>>> See attached file for example. Thanks advance for any help.
>>> Regards
>>> Vin
>>> --
>>> 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
>>> mailto:excel-macros%2bunsubscr...@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
>>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>> .
>>>
>>>
>>>
>>
>> --
>

Re: $$Excel-Macros$$ MS Excel Vlookup query

[vinod rao]

can i request you to put in the excel file. I am unable to get the relevelt
result

On Tue, Aug 21, 2012 at 12:02 AM, dguillett1  wrote:

>
> =INDEX($L$12:$O$26,SMALL(IF(($F$13=$L$12:$L$26),ROW($L$12:$L$26)-MIN(ROW($L$12:$L$26))+1,""),ROW(A1)),4)
> An array formula that must be entered using ctrl+shift+enter
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* vinod rao 
> *Sent:* Monday, August 20, 2012 1:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ MS Excel Vlookup query
>
>   Hi,
>
> I need a formula plz.
> My data base is very huge. i cannot use autofilter.
>
>  On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 wrote:
>
>>Just use data>filter>autofilter
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* vinod rao 
>> *Sent:* Monday, August 20, 2012 12:35 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ MS Excel Vlookup query
>>
>>Hi Team,
>>
>> I want to put vlookup or any other foumula and get the second/third
>> lookup data.
>>
>> See attached file for example. Thanks advance for any help.
>> Regards
>> Vin
>> --
>> 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
>> mailto:excel-macros%2bunsubscr...@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
>> mailto:excel-macros%2bunsubscr...@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.
>
&g

Re: $$Excel-Macros$$ MS Excel Vlookup query

[dguillett1]

  
=INDEX($L$12:$O$26,SMALL(IF(($F$13=$L$12:$L$26),ROW($L$12:$L$26)-MIN(ROW($L$12:$L$26))+1,""),ROW(A1)),4)
 

An array formula that must be entered using ctrl+shift+enter

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: vinod rao 
Sent: Monday, August 20, 2012 1:05 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ MS Excel Vlookup query

Hi,

I need a formula plz.
My data base is very huge. i cannot use autofilter.


On Mon, Aug 20, 2012 at 11:18 PM, dguillett1  wrote:

  Just use data>filter>autofilter

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: vinod rao 
  Sent: Monday, August 20, 2012 12:35 PM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ MS Excel Vlookup query

  Hi Team,

  I want to put vlookup or any other foumula and get the second/third lookup 
data.

  See attached file for example. Thanks advance for any help.
  Regards
  Vin
  -- 
  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 
mailto:excel-macros%2bunsubscr...@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 
mailto:excel-macros%2bunsubscr...@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.
 
 

-- 
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 atte

Re: $$Excel-Macros$$ MS Excel Vlookup query

[vinod rao]

Hi,

I need a formula plz.
My data base is very huge. i cannot use autofilter.

On Mon, Aug 20, 2012 at 11:18 PM, dguillett1  wrote:

>   Just use data>filter>autofilter
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* vinod rao 
> *Sent:* Monday, August 20, 2012 12:35 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ MS Excel Vlookup query
>
>   Hi Team,
>
> I want to put vlookup or any other foumula and get the second/third lookup
> data.
>
> See attached file for example. Thanks advance for any help.
> Regards
> Vin
> --
> 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.
>
>
>

-- 
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$$ MS Excel Vlookup query

[dguillett1]

Just use data>filter>autofilter

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: vinod rao 
Sent: Monday, August 20, 2012 12:35 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ MS Excel Vlookup query

Hi Team,

I want to put vlookup or any other foumula and get the second/third lookup data.

See attached file for example. Thanks advance for any help.
Regards
Vin
-- 
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.

$$Excel-Macros$$ MS Excel Vlookup query

[vinod rao]

Hi Team,

I want to put vlookup or any other foumula and get the second/third lookup
data.

See attached file for example. Thanks advance for any help.
Regards
Vin

-- 
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.




Book2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ MS-Excel Hanging

[zuhair Abdulhameed]

My Excel 2011 is stopped always

-- 
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

$$Excel-Macros$$ MS EXCEL 2007 and Significance Testing

[Sarah Seager]

I have data from two surveys. One survey was completed on 900 people
before a certain event happened, and then a second survey was
completed on a further 900 people after an event happened.

I need to calculate the % difference between the two whilst looking at
the demographics of the individuals.

E.g. difference between gender, ethnic group, age groups, etc.

I also then have to calculate the p-value of each of these to show
whether the difference between the pre and post surveys is
significant.

I'm guessing that a Chi-squared test is best for this, but how do I go
about doing this in excel?

Surely there's a simply way of just calculating the p-value of the
difference between the two surveys?

-- 
--
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$$ MS Excel MCQ Quiz

[XLS S]

Hey please see the answer :-


1-B, 2-D, 3-D, 4-B, 5-C, 6-D, 7-A, 8-C, 9-B, 10-A, 11-B, 12-C, 13-D, 14-B,
15-D, 16-B, 17-B, 18-A, 19-B, 20-C,



On Sat, Jul 23, 2011 at 9:49 AM, XLS S  wrote:

> MS Excel MCQ Quiz
>
>
> 1. You can use the formula pallette to
>
>  A) format cells containing numbers
>  B) create and edit formula containing functions
>  C) enter assumptions data
>  D) copy a range of cells
>
>
> 2. When a range is selected, how can you activate the previous cell?
>
>  A) Press the Alt key
>  B) Press Tab
>  C) Press Enter
>  D) None of above
>
>
> 3. Which tool you will use to join some cells and place the content at the
> middle of joined cell?
>
>  A) From Format Cells dialog box click on Merge Cells check box
>  B) From Format Cells dialog box select the Centered alignment
>  C) From Format Cells dialog box choose Merge and Center check box
>  D) Click on Merge and Center tool on formatting toolbar
>
>
> 4. Tab scroll buttons are place on Excel screen
>
>  A) towards the bottom right corner
>  B) towards the bottom left corner
>  C) towards the top right corner
>  D) towards the top left corner
>
>
> 5. The Name box on to the left of formula bar
>
>  A) shows the name of workbook currently working on
>  B) shows the name of worksheet currently working on
>  C) shows the name of cell or range currently working on
>  D) None of above
>
>
> 6. Each excel file is a workbook that contains different sheets. Which of
> the following can not be a sheet in workbook?
>
>  A) work sheet
>  B) chart sheet
>  C) module sheet
>  D) data sheet
>
>
> 7. Which of the following is not the correct method of editing the cell
> content?
>
>  A) Press the Alt key
>  B) Press the F2 key
>  C) Click the formula bar
>  D) Double click the cell
>
>
> 8. You can merge the main document with data source in Excel. In mail merge
> operation, Word is usually
>
>  A) server
>  B) source
>  C) client
>  D) none
>
>
> 9. How can you update the values of formula cells if Auto Calculate mode of
> Excel is disabled?
>
>  A) F8
>  B) F9
>  C) F10
>  D) F11
>
>
> 10. You want to set such that when you type Baishakh and drag the fill
> handle, Excel should produce Jestha, Aashadh and so on. What will you set to
> effect that?
>
>  A) Custom List
>  B) Auto Fill Options
>  C) Fill Across Worksheet
>  D) Fill Series
>
>
> 11. Where can you change automatic or manual calculation mode in Excel?
>
>  A) Double CAL indicator on status bar
>  B) Go to Tools >> Options >> Calculation and mark the corresponding radio
> button
>  C) Both of above
>  D) None of above
>
>
> 12. How can you show or hide the gridlines in Excel Worksheet?
>
>  A) Go to Tools >> Options >> View tab and mark or remove the check box
> named Gridline
>  B) Click Gridline tool on Forms toolbar
>  C) Both of above
>  D) None of above
>
>
> 13. Which of the following Excel screen components can NOT be turned on or
> off?
>
>  A) Formula Bar
>  B) Status Bar
>  C) Tool Bar
>  D) None of above
>
>
> 14. What happens when you press Ctrl + X after selecting some cells in
> Excel?
>
>  A) The cell content of selected cells disappear from cell and stored in
> clipboard
>  B) The cells selected are marked for cutting
>  C) The selected cells are deleted and the cells are shifted left
>  D) The selected cells are deleted and cells are shifted up
>
>
> 15. Which of the following option is not available in Paste Special dialog
> box?
>
>  A) Add
>  B) Subtract
>  C) Divide
>  D) SQRT
>
>
> 16. Which command will you choose to convert a column of data into row?
>
>  A) Cut and Paste
>  B) Edit >> Paste Special >> Transpose
>  C) Both of above
>  D) None of above
>
>
> 17. It is acceptable to let long text flow into adjacent cells on a
> worksheet when
>
>  A) data will be entered in the adjecent cells
>  B) no data will be entered in the adjacent cells
>  C) there is no suitable abbrevition for the text
>  D) there is not time to format the text
>
>
> 18. Which of the cell pointer indicates you that you can make selection?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 19. Which of the cell pointer indicates that you can fill series?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 20. Which of the cell pointer indicate that you can move the content to
> other cell?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 
> Regds
> 
> ???
> .
>
>

-- 
--
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://ww

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

[vijayajith VA]

hi

I need answers also pls

Thanks
On Sat, Jul 23, 2011 at 9:49 AM, XLS S  wrote:

> MS Excel MCQ Quiz
>
>
> 1. You can use the formula pallette to
>
>  A) format cells containing numbers
>  B) create and edit formula containing functions
>  C) enter assumptions data
>  D) copy a range of cells
>
>
> 2. When a range is selected, how can you activate the previous cell?
>
>  A) Press the Alt key
>  B) Press Tab
>  C) Press Enter
>  D) None of above
>
>
> 3. Which tool you will use to join some cells and place the content at the
> middle of joined cell?
>
>  A) From Format Cells dialog box click on Merge Cells check box
>  B) From Format Cells dialog box select the Centered alignment
>  C) From Format Cells dialog box choose Merge and Center check box
>  D) Click on Merge and Center tool on formatting toolbar
>
>
> 4. Tab scroll buttons are place on Excel screen
>
>  A) towards the bottom right corner
>  B) towards the bottom left corner
>  C) towards the top right corner
>  D) towards the top left corner
>
>
> 5. The Name box on to the left of formula bar
>
>  A) shows the name of workbook currently working on
>  B) shows the name of worksheet currently working on
>  C) shows the name of cell or range currently working on
>  D) None of above
>
>
> 6. Each excel file is a workbook that contains different sheets. Which of
> the following can not be a sheet in workbook?
>
>  A) work sheet
>  B) chart sheet
>  C) module sheet
>  D) data sheet
>
>
> 7. Which of the following is not the correct method of editing the cell
> content?
>
>  A) Press the Alt key
>  B) Press the F2 key
>  C) Click the formula bar
>  D) Double click the cell
>
>
> 8. You can merge the main document with data source in Excel. In mail merge
> operation, Word is usually
>
>  A) server
>  B) source
>  C) client
>  D) none
>
>
> 9. How can you update the values of formula cells if Auto Calculate mode of
> Excel is disabled?
>
>  A) F8
>  B) F9
>  C) F10
>  D) F11
>
>
> 10. You want to set such that when you type Baishakh and drag the fill
> handle, Excel should produce Jestha, Aashadh and so on. What will you set to
> effect that?
>
>  A) Custom List
>  B) Auto Fill Options
>  C) Fill Across Worksheet
>  D) Fill Series
>
>
> 11. Where can you change automatic or manual calculation mode in Excel?
>
>  A) Double CAL indicator on status bar
>  B) Go to Tools >> Options >> Calculation and mark the corresponding radio
> button
>  C) Both of above
>  D) None of above
>
>
> 12. How can you show or hide the gridlines in Excel Worksheet?
>
>  A) Go to Tools >> Options >> View tab and mark or remove the check box
> named Gridline
>  B) Click Gridline tool on Forms toolbar
>  C) Both of above
>  D) None of above
>
>
> 13. Which of the following Excel screen components can NOT be turned on or
> off?
>
>  A) Formula Bar
>  B) Status Bar
>  C) Tool Bar
>  D) None of above
>
>
> 14. What happens when you press Ctrl + X after selecting some cells in
> Excel?
>
>  A) The cell content of selected cells disappear from cell and stored in
> clipboard
>  B) The cells selected are marked for cutting
>  C) The selected cells are deleted and the cells are shifted left
>  D) The selected cells are deleted and cells are shifted up
>
>
> 15. Which of the following option is not available in Paste Special dialog
> box?
>
>  A) Add
>  B) Subtract
>  C) Divide
>  D) SQRT
>
>
> 16. Which command will you choose to convert a column of data into row?
>
>  A) Cut and Paste
>  B) Edit >> Paste Special >> Transpose
>  C) Both of above
>  D) None of above
>
>
> 17. It is acceptable to let long text flow into adjacent cells on a
> worksheet when
>
>  A) data will be entered in the adjecent cells
>  B) no data will be entered in the adjacent cells
>  C) there is no suitable abbrevition for the text
>  D) there is not time to format the text
>
>
> 18. Which of the cell pointer indicates you that you can make selection?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 19. Which of the cell pointer indicates that you can fill series?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 20. Which of the cell pointer indicate that you can move the content to
> other cell?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 
> Regds
> 
> ???
> .
>
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

[vijayajith VA]

Hi

I need answers also pls

thanks

On Sat, Jul 23, 2011 at 9:49 AM, XLS S  wrote:

> MS Excel MCQ Quiz
>
>
> 1. You can use the formula pallette to
>
>  A) format cells containing numbers
>  B) create and edit formula containing functions
>  C) enter assumptions data
>  D) copy a range of cells
>
>
> 2. When a range is selected, how can you activate the previous cell?
>
>  A) Press the Alt key
>  B) Press Tab
>  C) Press Enter
>  D) None of above
>
>
> 3. Which tool you will use to join some cells and place the content at the
> middle of joined cell?
>
>  A) From Format Cells dialog box click on Merge Cells check box
>  B) From Format Cells dialog box select the Centered alignment
>  C) From Format Cells dialog box choose Merge and Center check box
>  D) Click on Merge and Center tool on formatting toolbar
>
>
> 4. Tab scroll buttons are place on Excel screen
>
>  A) towards the bottom right corner
>  B) towards the bottom left corner
>  C) towards the top right corner
>  D) towards the top left corner
>
>
> 5. The Name box on to the left of formula bar
>
>  A) shows the name of workbook currently working on
>  B) shows the name of worksheet currently working on
>  C) shows the name of cell or range currently working on
>  D) None of above
>
>
> 6. Each excel file is a workbook that contains different sheets. Which of
> the following can not be a sheet in workbook?
>
>  A) work sheet
>  B) chart sheet
>  C) module sheet
>  D) data sheet
>
>
> 7. Which of the following is not the correct method of editing the cell
> content?
>
>  A) Press the Alt key
>  B) Press the F2 key
>  C) Click the formula bar
>  D) Double click the cell
>
>
> 8. You can merge the main document with data source in Excel. In mail merge
> operation, Word is usually
>
>  A) server
>  B) source
>  C) client
>  D) none
>
>
> 9. How can you update the values of formula cells if Auto Calculate mode of
> Excel is disabled?
>
>  A) F8
>  B) F9
>  C) F10
>  D) F11
>
>
> 10. You want to set such that when you type Baishakh and drag the fill
> handle, Excel should produce Jestha, Aashadh and so on. What will you set to
> effect that?
>
>  A) Custom List
>  B) Auto Fill Options
>  C) Fill Across Worksheet
>  D) Fill Series
>
>
> 11. Where can you change automatic or manual calculation mode in Excel?
>
>  A) Double CAL indicator on status bar
>  B) Go to Tools >> Options >> Calculation and mark the corresponding radio
> button
>  C) Both of above
>  D) None of above
>
>
> 12. How can you show or hide the gridlines in Excel Worksheet?
>
>  A) Go to Tools >> Options >> View tab and mark or remove the check box
> named Gridline
>  B) Click Gridline tool on Forms toolbar
>  C) Both of above
>  D) None of above
>
>
> 13. Which of the following Excel screen components can NOT be turned on or
> off?
>
>  A) Formula Bar
>  B) Status Bar
>  C) Tool Bar
>  D) None of above
>
>
> 14. What happens when you press Ctrl + X after selecting some cells in
> Excel?
>
>  A) The cell content of selected cells disappear from cell and stored in
> clipboard
>  B) The cells selected are marked for cutting
>  C) The selected cells are deleted and the cells are shifted left
>  D) The selected cells are deleted and cells are shifted up
>
>
> 15. Which of the following option is not available in Paste Special dialog
> box?
>
>  A) Add
>  B) Subtract
>  C) Divide
>  D) SQRT
>
>
> 16. Which command will you choose to convert a column of data into row?
>
>  A) Cut and Paste
>  B) Edit >> Paste Special >> Transpose
>  C) Both of above
>  D) None of above
>
>
> 17. It is acceptable to let long text flow into adjacent cells on a
> worksheet when
>
>  A) data will be entered in the adjecent cells
>  B) no data will be entered in the adjacent cells
>  C) there is no suitable abbrevition for the text
>  D) there is not time to format the text
>
>
> 18. Which of the cell pointer indicates you that you can make selection?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 19. Which of the cell pointer indicates that you can fill series?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 20. Which of the cell pointer indicate that you can move the content to
> other cell?
>
>  A) Doctor’s symbol (Big Plus)
>  B) small thin plus icon
>  C) Mouse Pointer with anchor at the tip
>  D) None of above
>
>
> 
> Regds
> 
> ???
> .
>
>
> --
>
> --
> 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. Exce

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

[Bhushan Sabbani]

please paste the ans. also.

-- 
--
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$$ MS Excel MCQ Quiz

[XLS S]

MS Excel MCQ Quiz


1. You can use the formula pallette to

 A) format cells containing numbers
 B) create and edit formula containing functions
 C) enter assumptions data
 D) copy a range of cells


2. When a range is selected, how can you activate the previous cell?

 A) Press the Alt key
 B) Press Tab
 C) Press Enter
 D) None of above


3. Which tool you will use to join some cells and place the content at the
middle of joined cell?

 A) From Format Cells dialog box click on Merge Cells check box
 B) From Format Cells dialog box select the Centered alignment
 C) From Format Cells dialog box choose Merge and Center check box
 D) Click on Merge and Center tool on formatting toolbar


4. Tab scroll buttons are place on Excel screen

 A) towards the bottom right corner
 B) towards the bottom left corner
 C) towards the top right corner
 D) towards the top left corner


5. The Name box on to the left of formula bar

 A) shows the name of workbook currently working on
 B) shows the name of worksheet currently working on
 C) shows the name of cell or range currently working on
 D) None of above


6. Each excel file is a workbook that contains different sheets. Which of
the following can not be a sheet in workbook?

 A) work sheet
 B) chart sheet
 C) module sheet
 D) data sheet


7. Which of the following is not the correct method of editing the cell
content?

 A) Press the Alt key
 B) Press the F2 key
 C) Click the formula bar
 D) Double click the cell


8. You can merge the main document with data source in Excel. In mail merge
operation, Word is usually

 A) server
 B) source
 C) client
 D) none


9. How can you update the values of formula cells if Auto Calculate mode of
Excel is disabled?

 A) F8
 B) F9
 C) F10
 D) F11


10. You want to set such that when you type Baishakh and drag the fill
handle, Excel should produce Jestha, Aashadh and so on. What will you set to
effect that?

 A) Custom List
 B) Auto Fill Options
 C) Fill Across Worksheet
 D) Fill Series


11. Where can you change automatic or manual calculation mode in Excel?

 A) Double CAL indicator on status bar
 B) Go to Tools >> Options >> Calculation and mark the corresponding radio
button
 C) Both of above
 D) None of above


12. How can you show or hide the gridlines in Excel Worksheet?

 A) Go to Tools >> Options >> View tab and mark or remove the check box
named Gridline
 B) Click Gridline tool on Forms toolbar
 C) Both of above
 D) None of above


13. Which of the following Excel screen components can NOT be turned on or
off?

 A) Formula Bar
 B) Status Bar
 C) Tool Bar
 D) None of above


14. What happens when you press Ctrl + X after selecting some cells in
Excel?

 A) The cell content of selected cells disappear from cell and stored in
clipboard
 B) The cells selected are marked for cutting
 C) The selected cells are deleted and the cells are shifted left
 D) The selected cells are deleted and cells are shifted up


15. Which of the following option is not available in Paste Special dialog
box?

 A) Add
 B) Subtract
 C) Divide
 D) SQRT


16. Which command will you choose to convert a column of data into row?

 A) Cut and Paste
 B) Edit >> Paste Special >> Transpose
 C) Both of above
 D) None of above


17. It is acceptable to let long text flow into adjacent cells on a
worksheet when

 A) data will be entered in the adjecent cells
 B) no data will be entered in the adjacent cells
 C) there is no suitable abbrevition for the text
 D) there is not time to format the text


18. Which of the cell pointer indicates you that you can make selection?

 A) Doctor’s symbol (Big Plus)
 B) small thin plus icon
 C) Mouse Pointer with anchor at the tip
 D) None of above


19. Which of the cell pointer indicates that you can fill series?

 A) Doctor’s symbol (Big Plus)
 B) small thin plus icon
 C) Mouse Pointer with anchor at the tip
 D) None of above


20. Which of the cell pointer indicate that you can move the content to
other cell?

 A) Doctor’s symbol (Big Plus)
 B) small thin plus icon
 C) Mouse Pointer with anchor at the tip
 D) None of above



Regds

???
.

-- 
--
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$$ MS Excel VBA Interview Questions & Answers

[OpenExcel.com]

Hi Friends,

Click here --> 
http://www.excelitems.com/2010/12/excel-vba-interview-questions.html

These Excel VBA Interview questions are being posted keeping in mind
that reader is aware of working with VBA, have some programming and MS
Excel background and is aware of terminologies. This question bank is
helpful for both Interviewee and Interviewer as it provides a quick
channel of questions and answers covering major topics of Excel and
VBA for quick revision.



Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ MS Excel help needed for newbie

[Mohammad Nazim]

Please check the sheet

Regards

On Thu, Oct 7, 2010 at 12:00 PM, Dean Brown wrote:

> I have several questions so if it's ok with you I'll ask then one at a
> time (that'll give me time to digest any answers).
>
> Ok, here's problem 1.
>
> I want the person using the spreadsheet to input a value into cell A1.
> The value that is input is going to be either A,B,C,D or E. The values
> of cells A2 and A3 will vary depending on what is input into A1.
>
> Basically (and in simple terms) what I want the formula to work out is
> this:
>
> If A1=A then A2=10 and A3=20
> If A1=B then A2=30 and A3=40
> If A1=C then A2=50 and A3=60
> If A1=D then A2=70 and A3=80
> If A1=E then A2=90 and A3=100
>
> I hope this makes sense. Any help is greatly appreciated.
>
> Regards.
>
> Dean.
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ MS Excel help needed for newbie

[siti Vi]

or, another formula in A2
*=MATCH(TRUE,A1={"A","B","C","D","E"},0)*20-10*
*
*
***
*
On Thu, Oct 7, 2010 at 4:23 PM, siti Vi  wrote:

> *formula in cell A2 *
> =CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90)
> *formula in cell A3*
> =A2+10
>
>
> On Thu, Oct 7, 2010 at 1:30 PM, Dean Brown wrote:
>
>> I have several questions so if it's ok with you I'll ask then one at a
>> time (that'll give me time to digest any answers).
>>
>> Ok, here's problem 1.
>>
>> I want the person using the spreadsheet to input a value into cell A1.
>> The value that is input is going to be either A,B,C,D or E. The values
>> of cells A2 and A3 will vary depending on what is input into A1.
>>
>> Basically (and in simple terms) what I want the formula to work out is
>> this:
>>
>> If A1=A then A2=10 and A3=20
>> If A1=B then A2=30 and A3=40
>> If A1=C then A2=50 and A3=60
>> If A1=D then A2=70 and A3=80
>> If A1=E then A2=90 and A3=100
>>
>> I hope this makes sense. Any help is greatly appreciated.
>>
>> Regards.
>>
>> Dean.
>>
>>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ MS Excel help needed for newbie

[siti Vi]

*formula in cell A2 *
=CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90)
*formula in cell A3*
=A2+10


On Thu, Oct 7, 2010 at 1:30 PM, Dean Brown wrote:

> I have several questions so if it's ok with you I'll ask then one at a
> time (that'll give me time to digest any answers).
>
> Ok, here's problem 1.
>
> I want the person using the spreadsheet to input a value into cell A1.
> The value that is input is going to be either A,B,C,D or E. The values
> of cells A2 and A3 will vary depending on what is input into A1.
>
> Basically (and in simple terms) what I want the formula to work out is
> this:
>
> If A1=A then A2=10 and A3=20
> If A1=B then A2=30 and A3=40
> If A1=C then A2=50 and A3=60
> If A1=D then A2=70 and A3=80
> If A1=E then A2=90 and A3=100
>
> I hope this makes sense. Any help is greatly appreciated.
>
> Regards.
>
> Dean.
>
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ MS Excel help needed for newbie

[Dean Brown]

I have several questions so if it's ok with you I'll ask then one at a
time (that'll give me time to digest any answers).

Ok, here's problem 1.

I want the person using the spreadsheet to input a value into cell A1.
The value that is input is going to be either A,B,C,D or E. The values
of cells A2 and A3 will vary depending on what is input into A1.

Basically (and in simple terms) what I want the formula to work out is
this:

If A1=A then A2=10 and A3=20
If A1=B then A2=30 and A3=40
If A1=C then A2=50 and A3=60
If A1=D then A2=70 and A3=80
If A1=E then A2=90 and A3=100

I hope this makes sense. Any help is greatly appreciated.

Regards.

Dean.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ MS Excel VBA cut and paste from multiple workbooks into one central Output worksheet.

[bbcdancer123]

So far I have created the first part of the macro which validates in
the'MASTER' worksheet the Filename (in 'Column A') and worksheet (in
'Column B') Validity parameters with a 'Yes' and 'No' text in ('Column
C').

Worksheet: MASTER
FilenameworksheetValidity
--
c:\Test\CBA.xls  Sheet1No
c:\Test\CBA1.xlsSheet2   Yes
c:\Test\CBA2.xlsSheet3   Yes

In columns D to G which extends left of the 'MASTER' worksheet, I have
the'copy' and 'paste' parameters required for the second part of the
macro.

Worksheet: MASTER extended to Columns D to G.

Column1   Column2  RowRecords

A C 20   5
A C 20   5
A B 20   1

In addition, I also have a final worksheet called 'OUTPUT' which will
holds the copy and pasted data from another workbook.

Worksheet: OUTPUT (Currently Empty)

Filename  Column1   Column2
--


>From the 'Master' worksheet the second record is validated with a
'Yes' text.

What I need is the second part of the macro to:

1) open the workbook 'c:\Test\CBA1.xls' go to 'Sheet2' copy the
data incells A20:A24 (see Below)

 Column A
---
Row20  A
Row21  A
Row22  A
Row23  A
Row24  A

   2) and paste it into the 'OUTPUT' worksheet in Column 1.

Worksheet: OUTPUT

Filename   Column1 Column2

A
A
A
A
A


  3) Copy the data in 'Sheet2' cells C20:C24 (see below) and paste it
into the OUTPUT worksheet in column2.


 Column C
-
Row20   C
Row21   C
Row22   C
Row23   C
Row24   C


Worksheet: OUTPUT
Filename   Column1  Column2
---
  AC
  AC
  AC
  AC
  AC

   4) Assign the five records as 'c:\Test\CBA1.xls' in Column called
'Filename'.

Worksheet: OUTPUT

Filename  Column1Column2
-
c:\Test\CBA1.xls A  C
c:\Test\CBA1.xls A  C
c:\Test\CBA1.xls A  C
c:\Test\CBA1.xls A  C
c:\Test\CBA1.xls A  C

   5) From the 'Master' worksheet the third record is validated with a
'Yes'.
Repeat point 1 to 4 again but this time with different copy and paste
parameters.

  Column A

Row20  B


Column B
---
Row20B


The records from point 5 should be added to the existing OUTPUT
table.

Worksheet: OUTPUT
FilenameColumn1   Column2
---
c:\Test\CBA1.xls  A C
c:\Test\CBA1.xls  A C
c:\Test\CBA1.xls  A C
c:\Test\CBA1.xls  A C
c:\Test\CBA1.xls  A C
c:\Test\CBA2.xls  B B

My CURRENT CODING FOR FIRST PART AS FOLLOWS:

DENOTES where the second part of the code should go.

' ** CUT AND PASTE FROM MULTI-WORKSHEETS LOGIC INSERTED HERE! **

If anyone can provide some help on the second part of my marco that be
great... Just can't seem to get the cut and paste from multiple
workbooks working. Many thanks!


Private Sub CommandButton2_Click()

Dim LRow As Integer
Dim strFullPath As String
Dim SheetName As String
Dim LContinue As Boolean

'Initialize variables
LContinue = True
LRow = 2
'Loop through all column A values until a blank cell is found

While LContinue

'Found a blank cell, do not continue

If Len(Range("A" & CStr(LRow)).Value) = 0 Then

   LContinue = False

'Check if file exists for part number

Else

'Place "No" in column B if the file does NOT exist

If Len(Dir(Range("A" & CStr(LRow)).Value)) = 0 Then

Range("C" & CStr(LRow)).Value = "No"

'Place "Yes" in column B if the file does exist

Else

Range("C" & CStr(LRow)).Value = "Yes"

'Open specific Workbook as a read only spreadsheet.

Workbooks.Open Filename:=Range("A" & CStr(LRow)), ReadOnly:=True


If Not SheetExists(Range("B" & CStr(LRow))) Then

'Worksheet does not exist!

Range("C" & CStr(LRow)).Value = "No"

Else

SheetName = Range("B" & CStr(LRow))Sheets(SheetName).Activate

' ** CUT AND PASTE FROM MULTI-WORKSHEETS LOGIC INSERTEDHERE! **

End If

'Close specific

Re: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

[Viraj Bhatia]

Could you please send me the file ..

thanks in advance..



On Sat, May 15, 2010 at 12:19 AM,  wrote:

> Yes, would you please send to me also? Many thanks.
>
> Sent from my BlackBerry Smartphone provided by Alltel
> --
> *From: *sudhir kumar 
> *Date: *Fri, 14 May 2010 21:23:43 +0530
> *To: *
> *Subject: *$$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach
>
> I friends, i have excel-2007 bible by john walkenbach, if anybody wants,
> just inform me, i will send to their e mail id.
> regards
> sudhir
>
> On Fri, May 14, 2010 at 10:14 AM, Mr excel  wrote:
>
>> i had also found 2003 version shall i upload it to the forum.
>>
>>
>> On Fri, May 14, 2010 at 10:12 AM, Mr excel wrote:
>>
>>> hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
>>> here.
>>>
>>>
>>>
>>> On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:
>>>
>>>> Hi Excel Masters,
>>>>
>>>> Could any one have MS-Excel Bible by john walkenbach e-book.
>>>> if so could please send it to me at 06n...@gmail.com.
>>>>
>>>>
>>>> Thanks in advance,
>>>>
>>>> Nani Ram
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> 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
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>>> about the learning and support from the group.Let friends and co-workers
>>>> know they can subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>
>>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Regards-
> Sudhir Kumar
> Design Engineer,
> Conceptia Software Technologies Pvt. Ltd.
> Email id-sudhir.p...@gmail.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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends an

$$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Harpreet Singh Gujral]

Mr excel,

Can you send the link for 2003 version

Thanks

Harry

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

[tanner . lj1]

Yes, would you please send to me also? Many thanks.
Sent from my BlackBerry Smartphone provided by Alltel

-Original Message-
From: sudhir kumar 
Date: Fri, 14 May 2010 21:23:43 
To: 
Subject: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

I friends, i have excel-2007 bible by john walkenbach, if anybody wants,
just inform me, i will send to their e mail id.
regards
sudhir

On Fri, May 14, 2010 at 10:14 AM, Mr excel  wrote:

> i had also found 2003 version shall i upload it to the forum.
>
>
> On Fri, May 14, 2010 at 10:12 AM, Mr excel  wrote:
>
>> hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
>> here.
>>
>>
>>
>> On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:
>>
>>> Hi Excel Masters,
>>>
>>> Could any one have MS-Excel Bible by john walkenbach e-book.
>>> if so could please send it to me at 06n...@gmail.com.
>>>
>>>
>>> Thanks in advance,
>>>
>>> Nani Ram
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[sudhir kumar]

I friends, i have excel-2007 bible by john walkenbach, if anybody wants,
just inform me, i will send to their e mail id.
regards
sudhir

On Fri, May 14, 2010 at 10:14 AM, Mr excel  wrote:

> i had also found 2003 version shall i upload it to the forum.
>
>
> On Fri, May 14, 2010 at 10:12 AM, Mr excel  wrote:
>
>> hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
>> here.
>>
>>
>>
>> On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:
>>
>>> Hi Excel Masters,
>>>
>>> Could any one have MS-Excel Bible by john walkenbach e-book.
>>> if so could please send it to me at 06n...@gmail.com.
>>>
>>>
>>> Thanks in advance,
>>>
>>> Nani Ram
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

[sudhir kumar]

I friends, i have excel-2007 bible by john walkenbach, if anybody wants,
just inform me, i will send to their e mail id.
regards
sudhir

On Fri, May 14, 2010 at 10:14 AM, Mr excel  wrote:

> i had also found 2003 version shall i upload it to the forum.
>
>
> On Fri, May 14, 2010 at 10:12 AM, Mr excel  wrote:
>
>> hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
>> here.
>>
>>
>>
>> On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:
>>
>>> Hi Excel Masters,
>>>
>>> Could any one have MS-Excel Bible by john walkenbach e-book.
>>> if so could please send it to me at 06n...@gmail.com.
>>>
>>>
>>> Thanks in advance,
>>>
>>> Nani Ram
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Mr excel]

i had also found 2003 version shall i upload it to the forum.

On Fri, May 14, 2010 at 10:12 AM, Mr excel  wrote:

> hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
> here.
>
>
>
> On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:
>
>> Hi Excel Masters,
>>
>> Could any one have MS-Excel Bible by john walkenbach e-book.
>> if so could please send it to me at 06n...@gmail.com.
>>
>>
>> Thanks in advance,
>>
>> Nani Ram
>>
>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Hemant K]

you can download it from this link

*http://www.easy-share.com/1909713544/Excel 2007 Bible.pdf

Regards
Hemant Koranne
*
On Fri, May 14, 2010 at 10:06 AM, Vikas Chouhan  wrote:

> me also send pleasvikask...@gmail.com
>
> On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com> wrote:
>
>> Hi Excel Masters,
>>
>> Could any one have MS-Excel Bible by john walkenbach e-book.
>> if so could please send it to me at 06n...@gmail.com.
>>
>>
>> Thanks in advance,
>>
>> Nani Ram
>>
>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Vikas Chauhan
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_ccess without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards

Hemant Koranne
Check out my web site for learning excel
http://exceltnt.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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Mr excel]

hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
here.


On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:

> Hi Excel Masters,
>
> Could any one have MS-Excel Bible by john walkenbach e-book.
> if so could please send it to me at 06n...@gmail.com.
>
>
> Thanks in advance,
>
> Nani Ram
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Vikas Chouhan]

me also send pleasvikask...@gmail.com

On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com> wrote:

> Hi Excel Masters,
>
> Could any one have MS-Excel Bible by john walkenbach e-book.
> if so could please send it to me at 06n...@gmail.com.
>
>
> Thanks in advance,
>
> Nani Ram
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
One Team One Dream One Goal

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Nani Ram]

Hi Excel Masters,

Could any one have MS-Excel Bible by john walkenbach e-book.
if so could please send it to me at 06n...@gmail.com.


Thanks in advance,

Nani Ram

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Paul Schreiner]

Yes, that's true.

Can you clear the data from the file and send me the BLANK sheet?
I'm really only trying to see if the lock/unlock is being set properly.

Paul





From: Jeff 
To: MS EXCEL AND VBA MACROS 
Sent: Wed, March 17, 2010 7:11:26 PM
Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking 
behavior



On Mar 17, 11:57 am, Paul Schreiner  wrote:
> Can you send me the file?

No, sorry I can't.  It's got confidential info.  So, stupid question,
but just wanna make sure ... with Locking checked and Sheet Protection
on, those cells should definitely not be accepting user input, right?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Jeff]

On Mar 17, 11:57 am, Paul Schreiner  wrote:
> Can you send me the file?

No, sorry I can't.  It's got confidential info.  So, stupid question,
but just wanna make sure ... with Locking checked and Sheet Protection
on, those cells should definitely not be accepting user input, right?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Dave Bonallack]

Sorry, I'm stumped. If the cell's locked and the sheet's protected, that should 
be that. Unless someone has figured out your sheet-protect password, and is 
just toying with you...

If it's repeatable, post a copy of the workbook.

Regards - Dave.
 
> Date: Wed, 17 Mar 2010 06:52:07 -0700
> Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell 
> locking behavior
> From: jeffhollifield1...@gmail.com
> To: excel-macros@googlegroups.com
> 
> I don't think my question was clear. I understand how to lock or
> unlock cells. The problem I'm having isn't with this. What I'm
> seeing is that when the Worksheet Protection is on, and a cell is
> Locked, that users are able to enter data into the cell anyway.
> 
> Has anyone seen this before or have any idea why this would be
> happening. There is no VBA in this workbook, so there's nothing
> behind the scenes happening to turn off sheet protection.
> 
> On Mar 17, 12:57 am, Dave Bonallack  wrote:
> > Hi,
> >
> > Each cell has to be locked for protection to have any effect.
> >
> > Select one of the cells that is disobediently accepting data
> >
> > Format, Cells, Protection tab, click 'Locked'
> >
> > Do this for each cell you want to lock, or you can select lots of cells in 
> > the ordinary way, or with the Ctrl key, and just do the 'Locked' thing once.
> >
> > Regards - Dave.
> >
> >
> >
> > > Date: Tue, 16 Mar 2010 10:35:15 -0700
> > > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell 
> > > locking behavior
> > > From: jeffhollifield1...@gmail.com
> > > To: excel-macros@googlegroups.com
> >
> > > Hi all,
> >
> > > I've got an Excel spreadsheet that is used for collecting some data
> > > from end users and each tab uses Sheet Protection with a password,
> > > with users able to select locked & unlocked cells. We also have a mix
> > > of locked & unlocked cells on each tab. There's also no VBA in this
> > > workbook.
> >
> > > On one tab, there are several locked cells which can take data entry.
> > > Does anyone have any idea why this would be the case? I always
> > > thought that if Sheet Protection was on, Excel prevented any entry
> > > into a locked cell.
> >
> > > --
> > > --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links 
> > > :http://twitter.com/exceldailytip
> > > 2. Join our Facebook Group 
> > > @http://www.facebook.com/group.php?gid=287779555678
> > > 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
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,800 subscribers worldwide and receive many nice notes 
> > > about the learning and support from the group.Let friends and co-workers 
> > > know they can subscribe to group 
> > > athttp://groups.google.com/group/excel-macros/subscribe
> >
> > _
> > Link all your email accounts and social updates with Hotmail. Find out 
> > now.http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 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
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from t

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Paul Schreiner]

Can you send me the file?
I can open it in excel2007 and see if it works the same way.
It definitely sounds suspicious.
It would be nice to determine if it is file-related
or Excel-version related...

Paul





From: Jeff 
To: MS EXCEL AND VBA MACROS 
Sent: Wed, March 17, 2010 9:52:07 AM
Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking 
behavior

I don't think my question was clear.  I understand how to lock or
unlock cells.  The problem I'm having isn't with this.  What I'm
seeing is that when the Worksheet Protection is on, and a cell is
Locked, that users are able to enter data into the cell anyway.

Has anyone seen this before or have any idea why this would be
happening.  There  is no VBA in this workbook, so there's nothing
behind the scenes happening to turn off sheet protection.

On Mar 17, 12:57 am, Dave Bonallack  wrote:
> Hi,
>
> Each cell has to be locked for protection to have any effect.
>
> Select one of the cells that is disobediently accepting data
>
> Format, Cells, Protection tab, click 'Locked'
>
> Do this for each cell you want to lock, or you can select lots of cells in 
> the ordinary way, or with the Ctrl key, and just do the 'Locked' thing once.
>
> Regards - Dave.
>
>
>
> > Date: Tue, 16 Mar 2010 10:35:15 -0700
> > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking 
> > behavior
> > From: jeffhollifield1...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Hi all,
>
> > I've got an Excel spreadsheet that is used for collecting some data
> > from end users and each tab uses Sheet Protection with a password,
> > with users able to select locked & unlocked cells. We also have a mix
> > of locked & unlocked cells on each tab. There's also no VBA in this
> > workbook.
>
> > On one tab, there are several locked cells which can take data entry.
> > Does anyone have any idea why this would be the case? I always
> > thought that if Sheet Protection was on, Excel prevented any entry
> > into a locked cell.
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our Facebook Group 
> > @http://www.facebook.com/group.php?gid=287779555678
> > 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe
>
> _
> Link all your email accounts and social updates with Hotmail. Find out 
> now.http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Jeff]

I don't think my question was clear.  I understand how to lock or
unlock cells.  The problem I'm having isn't with this.  What I'm
seeing is that when the Worksheet Protection is on, and a cell is
Locked, that users are able to enter data into the cell anyway.

Has anyone seen this before or have any idea why this would be
happening.  There  is no VBA in this workbook, so there's nothing
behind the scenes happening to turn off sheet protection.

On Mar 17, 12:57 am, Dave Bonallack  wrote:
> Hi,
>
> Each cell has to be locked for protection to have any effect.
>
> Select one of the cells that is disobediently accepting data
>
> Format, Cells, Protection tab, click 'Locked'
>
> Do this for each cell you want to lock, or you can select lots of cells in 
> the ordinary way, or with the Ctrl key, and just do the 'Locked' thing once.
>
> Regards - Dave.
>
>
>
> > Date: Tue, 16 Mar 2010 10:35:15 -0700
> > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking 
> > behavior
> > From: jeffhollifield1...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Hi all,
>
> > I've got an Excel spreadsheet that is used for collecting some data
> > from end users and each tab uses Sheet Protection with a password,
> > with users able to select locked & unlocked cells. We also have a mix
> > of locked & unlocked cells on each tab. There's also no VBA in this
> > workbook.
>
> > On one tab, there are several locked cells which can take data entry.
> > Does anyone have any idea why this would be the case? I always
> > thought that if Sheet Protection was on, Excel prevented any entry
> > into a locked cell.
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our Facebook Group 
> > @http://www.facebook.com/group.php?gid=287779555678
> > 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe
>
> _
> Link all your email accounts and social updates with Hotmail. Find out 
> now.http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[rf1234 rf1234]

Hello Dear,
It depends on which type of security you have there.if u write a code for
protection.
ensure to forcely enabled macro before openning workbook.









On Wed, Mar 17, 2010 at 10:27 AM, Dave Bonallack
wrote:

>  Hi,
> Each cell has to be locked for protection to have any effect.
> Select one of the cells that is disobediently accepting data
> Format, Cells, Protection tab, click 'Locked'
> Do this for each cell you want to lock, or you can select lots of cells in
> the ordinary way, or with the Ctrl key, and just do the 'Locked' thing once.
> Regards - Dave.
>
> > Date: Tue, 16 Mar 2010 10:35:15 -0700
> > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell
> locking behavior
> > From: jeffhollifield1...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > Hi all,
> >
> > I've got an Excel spreadsheet that is used for collecting some data
> > from end users and each tab uses Sheet Protection with a password,
> > with users able to select locked & unlocked cells. We also have a mix
> > of locked & unlocked cells on each tab. There's also no VBA in this
> > workbook.
> >
> > On one tab, there are several locked cells which can take data entry.
> > Does anyone have any idea why this would be the case? I always
> > thought that if Sheet Protection was on, Excel prevented any entry
> > into a locked cell.
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> Find out now. Link all your email accounts and social updates with
> Hotmail. <http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''&#x

RE: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Dave Bonallack]

Hi,

Each cell has to be locked for protection to have any effect.

Select one of the cells that is disobediently accepting data

Format, Cells, Protection tab, click 'Locked'

Do this for each cell you want to lock, or you can select lots of cells in the 
ordinary way, or with the Ctrl key, and just do the 'Locked' thing once.

Regards - Dave.
 
> Date: Tue, 16 Mar 2010 10:35:15 -0700
> Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking 
> behavior
> From: jeffhollifield1...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hi all,
> 
> I've got an Excel spreadsheet that is used for collecting some data
> from end users and each tab uses Sheet Protection with a password,
> with users able to select locked & unlocked cells. We also have a mix
> of locked & unlocked cells on each tab. There's also no VBA in this
> workbook.
> 
> On one tab, there are several locked cells which can take data entry.
> Does anyone have any idea why this would be the case? I always
> thought that if Sheet Protection was on, Excel prevented any entry
> into a locked cell.
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 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
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  
_
Link all your email accounts and social updates with Hotmail. Find out now.
http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

[Jeff]

Hi all,

I've got an Excel spreadsheet that is used for collecting some data
from end users and each tab uses Sheet Protection with a password,
with users able to select locked & unlocked cells.  We also have a mix
of locked & unlocked cells on each tab.  There's also no VBA in this
workbook.

On one tab, there are several locked cells which can take data entry.
Does anyone have any idea why this would be the case?  I always
thought that if Sheet Protection was on, Excel prevented any entry
into a locked cell.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe