call2shree
New Member
- Joined
- Nov 24, 2010
- Messages
- 15
Hi Experts,
Could you please create as macro based on the below mentioned details.
Sheet 1 as summary:
Button1 as Country { India,France and USA}
Button 2 as City {Hyderabad,Chennai and New jersy}
Button 3 as Submit.
Sheet 2 as Basedata
<TBODY>
</TBODY><COLGROUP><COL span=5></COLGROUP>
Sheet 3 as Output
Name Class Year City Country
When I select in Sheet1 Few parameters, those parameters pick from Basedata and show it in Output.
Example: In Sheet 1, Button 1 as County select as India and Button 2 as City select as Hyderabad.
In Sheet 3 Output pick the sheet 2 Hyderabad data..
Hope I give a breif about my requirment.please reply if you have any questions.
Thanks in Advance
Srinath
Could you please create as macro based on the below mentioned details.
Sheet 1 as summary:
Button1 as Country { India,France and USA}
Button 2 as City {Hyderabad,Chennai and New jersy}
Button 3 as Submit.
Sheet 2 as Basedata
Name </SPAN> | Class</SPAN> | Year</SPAN> | City</SPAN> | Country</SPAN> |
xxx</SPAN> | 2</SPAN> | 1999</SPAN> | Hyderabad</SPAN> | India</SPAN> |
aaa</SPAN> | 9</SPAN> | 2004</SPAN> | Chennai</SPAN> | India</SPAN> |
bbb</SPAN> | 7</SPAN> | 2007</SPAN> | Mumbai</SPAN> | India</SPAN> |
eee</SPAN> | 6</SPAN> | 2008</SPAN> | Paries</SPAN> | France</SPAN> |
www</SPAN> | 5</SPAN> | 2001</SPAN> | New jersy</SPAN> | USA</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=5></COLGROUP>
Sheet 3 as Output
Name Class Year City Country
When I select in Sheet1 Few parameters, those parameters pick from Basedata and show it in Output.
Example: In Sheet 1, Button 1 as County select as India and Button 2 as City select as Hyderabad.
In Sheet 3 Output pick the sheet 2 Hyderabad data..
Hope I give a breif about my requirment.please reply if you have any questions.
Thanks in Advance
Srinath