How to Pick the data from one sheet and paste in nother sheet?

[call2shree]

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

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

 

[Andrew Poulsom]

Do you mean data validation dropdowns rather than buttons? Why do you need a macro when formulas will do the job?

 

[call2shree]

Thanks for your reply..my requirments is need to select using validation my parameters. actually having more number of lines and Parameters.

 

[Andrew Poulsom]

Do you mean that a combination of country and city can occur more than once in your list on Basedata? if so please post some representative sample data and the expected results. Note that you could use Excel's built-in AutoFilter to achieve the result you want to see.