I need a function that will search through an array of data on one worksheet named "2010-2012", look for a matching term (say "apple"), then where it finds that term, select and copy all the cells in a range around it (from the row with "apple" down 5 rows and 7 columns), then paste that array to the worksheet named "Sheet1", and iteratively keep doing this until all the data has been reviewed and all matches copied to "Sheet1" without over writing itself.
What I have (that doesn't work) is:
Please Login or Register to view this content.
Bookmarks