nathandavies
03-20-2017, 11:43 AM
Hi all,
I'm after some help creating a index match formula in VBA, to populate a range of cells E-N based on column C, the index match will have to search multiple worksheets to find the correct Part Number.
I have some vba code which copies a 3 columns from a different workbook into 3 columns A,B,C & D but i want to search the workbook to populate columns E-N
I have attached my workbook for your assistance
Thanks.
ND18698
I'm after some help creating a index match formula in VBA, to populate a range of cells E-N based on column C, the index match will have to search multiple worksheets to find the correct Part Number.
I have some vba code which copies a 3 columns from a different workbook into 3 columns A,B,C & D but i want to search the workbook to populate columns E-N
I have attached my workbook for your assistance
Thanks.
ND18698