Index Match Automatically

[nathandavies9]

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.
ND

[Winon]

Hello nathandavies9,

Thank you for the sample Workbook.

May I please request that you attach a sample workbook with a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[nathandavies9]

Hello Windon,

Thank you for your response, i have populated an example workbook with a before and after worksheet, i have some vba code which populates columns A-C automatically, i would then require the remaining columns D-N to be populated from all the other worksheets including the formulas and formatting,i would also like to replace the information in column B if possible. also if there is no information found then it should return 0 in all the cells apart from column M which should put the following formula "=D4*IF((J4=0),((F4+(H4*I4))*E4),IF(E4=0, 0,F4+((G4*(K4*K4))*I4)))" that is based on Row 4.

I hope this helps, i will have around 20 sheets to look through but i have removed some of them to keep the attachment small enough to upload.

[nathandavies9]

Hi Windon, i think i have a solution but it keeps crashing my excel is that due to the size of my document?

Please Login or Register  to view this content.