In my worksheet Project, for the populated rows in column C, I use this index match formula to bring the notes from one WS into a consolidated WS: =INDEX(Project2!B:B, MATCH(Project!A:A,Project2!G:G,0))
Can someone help me rewrite this in VBA? I'd like to execute this with a quick button...