Search Macro, copy and paste

Closed
excelhelpme - Mar 10, 2010 at 02:16 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 12, 2010 at 11:03 AM
Hello,

I need help creating a macro.
The macros needs to search worksheet 1 for data, then copy and paste it to worksheet 2.

Worksheet 2 has 3 search fields:
Country:
Commodity:
Month:

I'd like to be able to type in a value in one or all of the 3 fields and then have the search button return the data to me below the search button in the same format it is on worksheet 1.

Thanks for the help,

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 12, 2010 at 11:03 AM
Question. Is the data in worksheet 1 that you are looking for is in specific cells or can it be any where. Could we have India and Indiana?
0