Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-08-2014, 11:49 AM
abautwag abautwag is offline Search through non-distinctive data Windows 7 64bit Search through non-distinctive data Office 2007
Novice
Search through non-distinctive data
 
Join Date: Apr 2014
Posts: 2
abautwag is on a distinguished road
Default Search through non-distinctive data

Is it possible to search through non-distinctive data using VBA?

For example:

Worksheet "A"

Column A
A1
A2
A3
A4
A5

Worksheet "B":
Column A | Column B | Column C
1/1/2014 | A1 | COMPLETE
1/2/2014 | A2 | STARTED
1/3/2014 | A3 | STARTED
1/4/2014 | A4 | COMPLETE
1/5/2014 | A3 | COMPLETE

I want to be able to search through Worksheet "B" for every value listed in Worksheet "A". If the value is found, I want the information listed in each row from Worksheet "B" into Worksheet "C". In this case, I should have 2 rows of information for "A1". I haven't started on the code yet but I am getting lost in the logic with creating a loop to continue to search for "A1" until all values have been found, copied, and pasted, and then search for A2, A3.. etc.




Is this possible to do?

Thanks.

Last edited by abautwag; 04-08-2014 at 11:52 AM. Reason: Formatting was off ...
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Search for date and then apply mutliple search criteria in huge dataset maxtymo Excel 2 12-01-2013 04:52 AM
Looking for Windows Search app with ability to search by content gopher_everett Office 1 02-28-2013 09:23 PM
Search through non-distinctive data Data table search function omtinole Excel Programming 1 07-13-2012 10:03 PM
Using data entered in prompt to search database table BluRay Word 1 03-25-2011 01:47 AM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:28 AM.


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