I need some help copying data from one excel worksheet to another. For example:
Sample Data
__A__B___C
1 aaa bbb ddd
2 bbb ccc eee
3 ccc fff rrr


4 ccc fff ttt
5 ddd eee ggg
6 aaa ddd eee
7 bbb fff hhh
8 eee eee eee
So for the above records if I do a 'CTRL + F' and search to find All 'eee' the results will show 6 instances in C2, B5, C6, A8, B8, C8
Now I want to copy the whole of rows 2,5,6 and 8 to another worksheet.

Hi
Have a look at the following link which may give you a solution.
Good luck.
Tony

http://forums.techguy.org/business-a...onal-copy.html

This has solved it