jimjoseph
asked on
How to transfer Rows from the results of "Find' function in Excel 2010 to another sheet
Dear Friends
I have a user with a excel workbook. What the user wants is that after using the "Find & Select" function in excel to search of certain texts/data/number, the results will be shown as attached (see picture) if found in the sheet. Can the entire rows of the results found be copied onto another sheet after that? I am not great at either VB or macros. So hopefully someone can help me out with this.
Find-and-Replace.JPG
I have a user with a excel workbook. What the user wants is that after using the "Find & Select" function in excel to search of certain texts/data/number, the results will be shown as attached (see picture) if found in the sheet. Can the entire rows of the results found be copied onto another sheet after that? I am not great at either VB or macros. So hopefully someone can help me out with this.
Find-and-Replace.JPG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sigh.
14 January 2014: A grading of 'B' (good) without any further communication from the question asker after my proposed solution posted almost four months ago.
14 January 2014: A grading of 'B' (good) without any further communication from the question asker after my proposed solution posted almost four months ago.
You can use this option to analyse a table of data and pull out rows which meet certain criteria. The rows can be shown in place or copied to another sheet.
Thanks
Rob H