How do I copy and paste rows with a certain value from one worksheet to another in Microsoft Excel?

Question

I am trying to create a macro in Microsoft Excel. The first sheet is a data sheet with company names in the first column, and additional information in the next columns. I have several worksheets in which I'd like to specify the company name and then copy all rows from that company into that worksheet. Does anyone know the keystrokes or formulas so I can add a macro that will do this?

Answer 1

I've uploaded an Excel workbook with a macro that moves data from the "Master" worksheet to sheet WS2 when the company name is entered in column A of WS2 (the company name must be exact)

http://www.savefile.com/files/1751782

Have fun!