![]() |
#1
|
|||
|
|||
![]()
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 ... |
|
![]() |
||||
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 |
![]() |
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 |