nbranch1311
New Member
- Joined
- Jun 6, 2016
- Messages
- 1
Hello,
I am still slightly new to VBA but I have a complex (or at least to me) situation that makes me feel like I will need a helper function (used to coding in Java or C)
So for the first part. I need the code to be able to reference a cell in workbook (not sheet) and compare it to values in a column in a different workbook. If they are the same then return the cell address. for example = CELL("address", INDEX('TEST Active.xlsx'!Table1[Unique Key], MATCH(C2, 'TEST Active.xlsx'!Table1[Unique Key], 0))). This part works. Now I need to have a formula to take the row of the returned values and check particular cells in that row for values found in the cell of that activeselection running this statement
I am still slightly new to VBA but I have a complex (or at least to me) situation that makes me feel like I will need a helper function (used to coding in Java or C)
So for the first part. I need the code to be able to reference a cell in workbook (not sheet) and compare it to values in a column in a different workbook. If they are the same then return the cell address. for example = CELL("address", INDEX('TEST Active.xlsx'!Table1[Unique Key], MATCH(C2, 'TEST Active.xlsx'!Table1[Unique Key], 0))). This part works. Now I need to have a formula to take the row of the returned values and check particular cells in that row for values found in the cell of that activeselection running this statement
