|
|
|
|
#2
02-05-2013, 05:50 PM
|
|||
|
|||
Hi OPM, here is my question in a slightly changed manner.
I would like help in writing VBA for a Macro activated by a control button in my spreadsheet. The spreadsheet has mixed number and letter entries in column L eg. 19:44:B5 I will paste onto the sheet, 3 additional columns R,S and T, these columns Will have about 400 rows. One cell in column R will have the matching cell value As listed above for Column L eg 19:44:B5 I would select a cell in Column L and activate the Macro. The Macro would search The 400 rows in column R and once it located the matching data in the cell in Column R Would copy the matching data next to the selected cell in Column L and also copy the Additional data that is in Column S and T that are next to In the end I would have Column L,R,S and T would look like 19:44:B5, 19:44:b5, data,data Any help would be appreciated Matthew 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
 Possible Lookup
|
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
|
LookUp
|
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
| Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
|
Using the LOOKUP Command
|
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode