#1
|
|||
|
|||
Lookup Macro
I would like help if possible in making a lookup Macro activated by a button in data spreadsheet.
I have a data sheet that has Column R=has data, Column S has more data and Column T has an address contains mixed number and letter eg r1 = hdlp, s1 = blue, t1 = 19:33:b8 r2 = can, s2 = green , t2 = 19:44:b5 these 3 data rows go on for about 400 rows. I copy my lookup sheet into columns A to L, this sheet can contain 30000 or more rows The column L has a similar value found in somewhere in one of cells in column T What I would like is a macro that once activated would go to the first value in row1 of column L find the exact match in row t and insert the corresponding value in colums R1 and S1, then go to the next row in column L and repeat the same process until all the values in Column L has their correspoing data value inserted from columns R and S into the columns M & N In the end I would have Column L,M & N look like 12:44:b5 can green and so on Any help would be appreciated Matthew |
#2
|
|||
|
|||
Hi
Can you post a sample and I will take a look for you later this evening. Tony |
#3
|
|||
|
|||
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 |