Copy Cells From Multiple Sheets To One Sheet

[scarlettw123]

I need the great macro wizards to help me please. I need a macro that copies certain columns to another sheet in my work book. The information I want to copy is 4 rows down from the cell that contains the word "components" in columns C, U, and AC. The Sheet name the information is in is named "1094022047". I need it to paste to sheet named "9HP" in columns A B and C. I have 30 other sheets that are formated the same way as sheet"1094022047" that also needs to be transfered to the same columns in sheet "9HP". Is there anyway to create a macro to do this function for all 31 sheets and a message box that says," information copied successfully? I hope my attachment helps!

[davesexcel]

This is a duplicate thread.

http://www.excelforum.com/excel-prog...t=#post3973155