VBA Macro Search and copy Tutorial

[nairion]

Can someone link to a basic primer for some search and copy functions?

I'm needing to copy/paste information from specific cells, that are identified based on cells in the same row from multiple workbooks in different folder locations.

IE. I need a macro that opens a workbook, looks at every sheet, identifies which cells contain certain information, copy that whole row, paste it into another worksheet in a different file from 4-5 different sources with different formats.

So basically, it's time to learn how to fish. Can you guys send me to the right learning portal?

 

[pbornemeier]

Using Google Search: copy specific rows from one sheet to another site:mrexcel.com
A few useful responses are found:
http://www.mrexcel.com/forum/excel-...-one-worksheet-another-worksheet-if-cert.html
http://www.mrexcel.com/forum/excel-questions/711277-macro-copy-specific-rows-another-workbook.html
http://www.mrexcel.com/forum/excel-...ent-worksheet-based-specific-cell-values.html

Turn on the macro recorder and perform the actions that you want to automate.
Modify the code to be more flexible by following the links above and other links returned by the google search
Ask questions on this site based on your code. - be sure to read posting guidelines (see link in my sig).