Search : in
By :

MACRO to copy rows based on critera

JxCore, on Oct 15, 2008 2:10:58 pm BST 
 Report this message to moderators

Hello,

I need to create a Macro in Excel 2003 that will search four worksheets (within the same workbook) for the word "Failed" and then copy the entire row that word exists in to another worksheet (within the same workbook). I need the formatting in the destination worksheet to stay the same.

Worksheet names I need to pull information from are "A Plant," "Select," "HE Services," and "Other." Worksheet name I need to place the information is "Oct Total Summary."

Thank you for your help!

Configuration: Windows XP
Firefox 2.0.0.16

Best answers for « MACRO to copy rows based on critera » in :
Copy rows based on a condition Show Copy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
Copy rows based on a condition Show
Copy paste and delete rows based on a criteri Show
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply
Ask your question Reply
They need your help