| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using EQUIV and INDEX fonction in vba
Hello,
I have a database which is like the folowing (sheet #1): Column 1 is an index (like SSN) Column 2 to 27 is data I would like to make a second sheet which is linked to the first sheet using reference formula. So, the order of the sheet#1 can change without affecting the sheet #2. I have tried to program that but does't work well. c = ActiveSheet.Name ActiveSheet.Copy Befo=Sheets(1) d = ActiveSheet.Name Columns("B:B").Insert ' This column will contain the MATCH function Range("B3:B100").FormulaR1C1 = "=MATCH(RC[-1]," & c & "!A:A,0) 'this gives #NAME in excel but if I click on, excel calcul the value Range("C3:AB100").FormulaR1C1 = "=INDEX('" & c & "'!A:AZ,'" & d & "'!RC[1]," & column()-1 & ")" Any idea ? Thanks ! -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countifs equiv in 2003 | Excel Discussion (Misc queries) | |||
| Max() Dmax() Looking for MaxIf() Equiv. | Excel Worksheet Functions | |||
| Help with max() fonction | Excel Worksheet Functions | |||
| Using "Equiv" excel fonction in vba | Excel Programming | |||
| =FONCTION(CELLULE(A1)) ? | Excel Programming | |||
Threaded Mode
