If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VB Macro for Match Index
HI All,
I need your help to write a Macro which will match a string in all the sheets and Index the corresponding values next to it. Eg i have 4 sheets in a Workbook. in the sheet4 i have values A1: 8001 A2:8002 A3:8003 .... .... and sheet1,sheet2,sheet3 as values like this A1:7001 B1: Sold A2:8002 B2:Not sold A3:6005 B3: Not sold .... .... .... Now in Sheet4, I want to search for values in range A:A(sheet4) in all the other sheets in the workbook and Index the corresponding values in Range B:B. I know how to use Match Index function, but i want to write a code what will match the value in all the sheets in the workbook and retrieve the corresponding value. In addition to that.. I would also like to know the code snippet if i want to run this code to retrieve values from other excel file and not from the other sheets of the same file. Hope I am able to express my query. Any help will be appreicated |
Thread Tools | |
Display Modes | |
|
|