Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-18-2016, 03:12 PM
Auto Auto is offline Find matching criterior in sheet 1 and copy to Sheet 2 Windows 8 Find matching criterior in sheet 1 and copy to Sheet 2 Office 2007
Novice
Find matching criterior in sheet 1 and copy to Sheet 2
 
Join Date: Mar 2016
Posts: 9
Auto is on a distinguished road
Question Find matching criterior in sheet 1 and copy to Sheet 2

Can someone write a VBA code for this? I would like to search for something like "COMCAST" in column "A" of sheet 1 and have those rows appear in sheet 2. On the next search clear sheet 2 and copy the new search data over to sheet 2. I hope this makes sense.

Sample file is attached.



Also, how do you mark a post as "SOLVED"? I look everywhere and can't find how to do it. Thanks everyone who responds.
Attached Files
File Type: xlsx Totals.xlsx (35.5 KB, 12 views)
Reply With Quote
 

Tags
vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to find a macro that will copy a cell and paste that value to a specific sheet bryans88 Excel Programming 1 12-23-2015 01:40 PM
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM
Find matching criterior in sheet 1 and copy to Sheet 2 matching data from one work sheet to another, then auto filling missing cell information timomaha Excel 1 09-12-2014 07:51 AM
Find matching criterior in sheet 1 and copy to Sheet 2 Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 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 02:34 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