View Full Version : [SOLVED] Index Match Over Multiple Worksheets

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


03-20-2017, 12:31 PM
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.