Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2013, 07:33 AM
khalidfazeli khalidfazeli is offline Find Results in excel copy the rows to another sheet Windows 8 Find Results in excel copy the rows to another sheet Office 2010 32bit
Novice
Find Results in excel copy the rows to another sheet
 
Join Date: Feb 2013
Posts: 2
khalidfazeli is on a distinguished road
Default Find Results in excel copy the rows to another sheet

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.
Reply With Quote
  #2  
Old 02-06-2013, 08:20 AM
OTPM OTPM is offline Find Results in excel copy the rows to another sheet Windows 7 32bit Find Results in excel copy the rows to another sheet Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 02-06-2013, 09:38 AM
khalidfazeli khalidfazeli is offline Find Results in excel copy the rows to another sheet Windows 8 Find Results in excel copy the rows to another sheet Office 2010 32bit
Novice
Find Results in excel copy the rows to another sheet
 
Join Date: Feb 2013
Posts: 2
khalidfazeli is on a distinguished road
Default

This has solved it
Reply With Quote
Reply

Tags
excel 2010, macro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Results in excel copy the rows to another sheet Find, copy and paste into a new page jperez84 Word VBA 24 09-20-2012 11:34 AM
Find Results in excel copy the rows to another sheet Macro that can find phrase and then find another and copy jperez84 Word VBA 10 09-19-2012 04:48 PM
How to Copy data from Outlook mail and Paste it in a Excel sheet? padhu1989 Outlook 0 09-11-2012 04:07 AM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft