Friday, 20 September 2013

[www.keralites.net] Excel Tip: How to create A drop-down list

 

 

If you're creating a worksheet that will require user input and you want to minimize data entry errors, use Excel's data validation feature to add a drop-down list. The best part about it is that you don't have to write any macros.
 

Data validation is an excellent way to ensure that a cell entry is of the proper data type (text, number, or date) and within the proper numeric range. The drop-down list produced with the feature appears when a user clicks the cell.

Here's how to create a drop-down list:

  1. Type the list of valid entries in a single column. If you like, you can hide this column (select Format, Column, Hide).
  2. Select the cell or cells that will display the list of entries.
  3. Choose Data, Validation, and select the Settings tab.
  4. From the Allow drop-down list, select List.
  5. In the Source box, enter a range address or a reference to the items that you entered in step 1.
  6. Make sure the 'In-cell dropdown' box is selected.
  7. Click OK.

If your list is short, you can skip step 1 and type the list entries directly in the Source box in step 5, separating items with a comma.

The Data Validation dialog box has two other tabs. Click Input Message to add a prompt that will appear when a user selects a cell. Click Error Alert to specify a custom error message if the user's entry is invalid.

The handy data validation feature suffers from one serious flaw. If you paste an entry into a cell that uses data validation, the validation isn't performed. And if you select that cell again, the drop-down list no longer appears. Fortunately, you can circumvent this problem by protecting the worksheet: Select Tools, Protection, Protect Sheet.
 

http://spreadsheetpage.com/index.php/tip/create_a_drop_down_list_of_possible_input_values/

Alternately you can
w
atch this video to learn it

http://www.youtube.com/watch?v=VDwFTSQ-OQA

 


www.keralites.net

__._,_.___
Recent Activity:
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net
.

__,_._,___

[www.keralites.net] requirement of reapplying family visa (UAE).

 
__._,_.___
Recent Activity:
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net
.

__,_._,___

[www.keralites.net] Re: A GREAT RELIEF for the Common Man.

 

As per RBI during 2012-13 the TOTAL transactions through different modes are given below. 2% of Rs. 1,312,471 trillion will be Rs. 2,624,942 Crores
which is much more than the expenditure during 2012-13. Hassle FREE collection and NO BLACK MONEY.

THE CHANCES ARE THAT THE COLLECTION MAY GO UP BY 200% T0 300% if all transactions are routed through Banks.


http://www.rbi.org.in/scripts/AnnualReportPublications.aspx?Id=1087
 

Payment System Indicators - ANNUAL TURN (Rs. In Trillions)

Item

2012-13

Systemically Important Payment Systems (SIPS)

 

1. RTGS

₹ 676,841.00

Total RTGS (1)

₹ 676,841.00

Financial Markets Clearing

 

2. CBLO

₹ 120,480.40

3. Government Securities Clearing

₹ 119,948.00

4. Forex Clearing

₹ 261,170.10

Total Financial Markets Clearing (2-4)

₹ 501,598.50

5. C T S

₹ 21,779.50

6. MICR Clearing

57,504.00

7. Non-MICR Clearing

20,898.30

Total MICR Non-MICR Clearing (5-7)

100,181.80

Retail Electronic Clearing

 

8. ECS DR

1,083.10

9. ECS CR

1,771.30

10. EFT/NEFT

29,022.40

Total Retail Electronic Clearing (8-10)

31,876.80

Cards

 

11. Credit Cards

1,229.50

12. Debit Cards

743.40

Total Cards (11-12)

1,972.90

Total Others (5-12)

134,031.50

Grand Total (1-12)

1,312,471.00


On 21 September 2013 02:07, Himeshwar Pandit <
hemu.is.back@gmail.com> wrote:
 
Did you mean by another RAM MANDIR.....a dream which has remained unfilfilled Mr. menon.
Well, I hope, wish and pray that all such dreams come true.
But the immediate fall out of this plan would be closing of large number of offices under the finance Ministry connected with Income tax, sales tax, excise duty and scores of other taxes.
The govt will be saddled with responsibility for finding alternative employment for theses employees. 
 
On Fri, Sep 20, 2013 at 1:24 PM, Ics Menon <ics.menon@gmail.com> wrote:
 
it will be another RAM MANDIR?
 
On Fri, Sep 20, 2013 at 9:15 AM, Gangadharan Nair N <ng.puthoor@gmail.com> wrote:

BJP looks at a tax-free Raj                  

Sep 19, 2013 - Sanjay Basak and Pawan Bali |

 In a so-called "bid to transform the current Indian socio-economic scenario" and "provide relief to the middle class while boosting the industrial sector", the BJP is looking at a "revolutionary" five-point proposal to abolish all direct and indirect taxes (except customs duty to protect domestic markets), including income-tax, excise duties, service tax, sales tax, VAT and corporate tax, among others.
A think-tank,
Arthakranti, had a series of meetings with the top BJP leadership, including Mr L.K. Advani and Mr Narendra Modi, to discuss the proposal. Even RSS chief Mohan Bhagwat has been briefed about the proposal. Instead of direct and indirect taxes, the think-tank has proposed to impose a tax like "say 2%" on every banking transaction.
While the BJP leadership, which is preparing its "vision document", is debating the proposal, the national spokesman of the think tank, Mr Deepak Karanjikar, claimed that
"it will generate a revenue of Rs. 15 lakh crore" for the government. The proposal, incidentally, will take at least three years for implementation if accepted by the ruling party at the Centre. A draft parliamentary bill has also been prepared for the "new taxation system" by the think-tank. Some in the BJP are, however, sceptical about the proposal. "We are only looking at it at this juncture," a senior BJP functionary said.
As per the proposal, the transaction tax on credit accounts will be shared by the Centre, states, local authorities and the transacting bank. High denomination currency above
Rs.50/- is proposed to be abolished. "Some 58% of the population pays Rs. 20/- a day so they will not be affected by this," said Mr Karanjikar.
Under the proposal, currency transactions will not attract any transaction tax. But, it is proposed, cash transactions above a level, say
Rs. 2,000/-, will be deemed illegal. "If you buy anything, like a camera, above this limit in cash and if there is some problem with the product, you will not be able to enforce the warranty on it as the transaction will be considered illegal," said Mr Karanjikar.
The biggest challenge to this proposal will be that in most of rural India, there are no banks. But, Mr Karanjikar said, the think-tank is right now chalking out modalities for it. "The banking infrastructure will have to be made. Ultimately, even the Food Security Bill will not be implemented without developing the banking system. We are planning a plan looking at the Aadhaar system," he added.
Arthakranti said that its proposal will bring more transparency and tackle the issue of black money. "The removal of instruments of parallel economy, that is high denomination rupee notes, means increased traceability," it said. The proposal could bring down prices of products and services due to abolition of Excise, Services and Sales Taxes. This may enhance customer base and could boost industrial production. It will bring stability in business circles about the tax laws of the country. Currently, the income-tax department and various top MNCs are involved in litigation over tax issues. It will also save compliance costs of the corporates as they will not need to pay any taxes.

Visit :-  http://www.asianage.com/india/bjp-looks-tax-free-raj-578

"Na Mo Namasivaya",  'Vande Matharam'
 Gangadharan Nair N.
"Sab Ke Saath, Sab Ka Vikas"

 
Please visit:  www.arthakranti.org
"Dharmam Saranam Gachhami"
 
"Make Giving Bribe Exposing it, Legal a Birth Right of every citizen of INDIA,
but
Demand
ing or Accepting Bribe Illegal a willful act of Crime,"

We had a DREAM of Principled, Prosperous Peaceful INDIA are committed to fulfill that DREAM.


www.keralites.net

__._,_.___
Recent Activity:
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net
.

__,_._,___

Re: [www.keralites.net] NRI v/s INR

 

The following is the notification in UAE Mashreq Bank site in which it clearly says that Indian National are allowed to bring IR 7500/- into India:
 

Notice for people travelling to India

Dear Customers,

We wish to inform you that, as of 22/05/2013, the Indian Central Board of Excise and Customs (CBEC) has criminalized carrying Indian currency into India. It is important that our customers stay up-to-date in order to avoid any legal consequences.

The new law stipulates the following:
Kindly note that failure to abide by the above could result in confiscation of money, prosecution, and imprisonment.

 

Anoop.
From: Jyothi Kurien
To: Keralites@yahoogroups.com
Sent: Friday, September 20, 2013 7:46 AM
Subject: [www.keralites.net] NRI v/s INR
 

NRIs, foreigners can't leave with rupee

Sep 19, 2013, 06.02AM IST 

MUMBAI: Thanks to a new directive from the Reserve Bank of India (RBI), from now on every non-resident Indian (NRI) and foreigner leaving the country will have to compulsorily change Indian rupees in their possession into a foreign currency before they board the flight. It's a common practice among NRIs to carry some amount of Indian currency with them when they leave the country, mainly for the convenience of not having to exchange forex into rupee when they return the next time. But from now on, they will not be allowed to carry any Indian notes with them.

Although the rule, which is part of Foreign Exchange Management Act (FEMA), has been in place for quite some time now, it is only now that the central bank is trying to enforce it. On Monday, RBI allowed forex changers to open kiosks beyond the immigration desks at international airports to facilitate NRIs and
foreigners opting to exchange rupee for other currencies before they enter the aircraft. According to RBI officials, in case these travellers have Indian currency notes in their possession before boarding the flight, Indian customs officials can act against them.

RBI has allowed NRIs to carry up to Rs 10,000 beyond the immigration and customs desks, and to the duty-free shopping and security checking areas in the departure hall in international airports to meet miscellaneous expenses. However, this has been allowed subject to the condition that NRIs "will not be allowed to carry any Indian rupee beyond SHA and that they should dispose of Indian currency before boarding the plane", an RBI notification said.

To facilitate money changing facilities for NRIs and foreigners, foreign exchange counters have been allowed in departure halls in international airports beyond the immigration and customs desks. "Such foreign exchange counters will, however, only buy Indian rupees from non-residents and sell foreign currency to them subject to usual terms and conditions," RBI said. It has also directed authorities to put up displays at international airports, "reminding passengers that the area is the last point for non-residents to possess Indian Rupees".

__._,_.___
Recent Activity:
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net
.

__,_._,___

[www.keralites.net] ==>> The Balad Sayt Village, Oman

 
__._,_.___
Recent Activity:
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net
.

__,_._,___