Index Match Over Multiple Worksheets

[nathandavies]

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.
NDexample.xlsm

[mdmackillop]

I don't see any data to find or copy. Do the part numbers appear on more than one sheet? Is all the data to be copied from one sheet? Please provide a better example.