Hi Anil,
The drop downs in the spreadsheet have been made using 'Data Validation'.
In Excel 2007 this can be found under the ribbon 'Data' - click on Data
Validation' - choose "list" from the options under Allow.
The source section will contain your metadata, ie the data which you wish to
view from the drop-down options.
If I am not clear then let me know and I can breakdown the explanation. But if
you google "Data Validation Excel" you should get examples.
Thanks,
Amitabh
Date: Wed, 14 Oct 2009 15:20:25 +0530
Subject: $$Excel-Macros$$ xls.
From: anilsaxena170...@gmail.com
To: dilipan...@gmail.com
CC: excel-macros@googlegroups.com
HI,
Please find attached file of .xls & give instruction how can i creat new sheet
like this.
Regards,
Anil Saxena
_________________________________________________________________
Chat to your friends for free on selected mobiles
http://clk.atdmt.com/UKM/go/174426567/direct/01/
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
