1. In a folder (Folder path C:\david\Desktop\New folder) , I have file name called " Data" and sheet name "Data info" and another file name called "System" and sheet name "system info"
2. I need to perform formula with Data workbook and system workbook. Formula need to apply in System workbook.
3. Below is the formula
In my case Sheet2 in the formula is Data workbook,
=IFERROR(INDEX(Sheet2!$H$2:$H$45812,MATCH(J280&"|"&Q280,INDEX(Sheet2!$C$2:$C$45812&"|"&Sheet2!$H$2:$H$45812,0),0)),"") in Z column
=IFERROR(INDEX(Sheet2!$C$2:$C$45812,MATCH(J280&"|"&Q280,INDEX(Sheet2!$C$2:$C$45812&"|"&Sheet2!$H$2:$H$45812,0),0)),"") in AA column
J and Q column is from the System workbook
Formula should apply till the last row of the Data workbook.
4. Once forumula runs in the System workbook column Z and AA
I would like to match the values in AC column =Z2=Q2 till last row and in AD column =AA2=J2
5. Filter for true value in both columns and update status as Yes in V
since my data is huge , I would like to do VBA.
Thank you in advance
2. I need to perform formula with Data workbook and system workbook. Formula need to apply in System workbook.
3. Below is the formula
In my case Sheet2 in the formula is Data workbook,
=IFERROR(INDEX(Sheet2!$H$2:$H$45812,MATCH(J280&"|"&Q280,INDEX(Sheet2!$C$2:$C$45812&"|"&Sheet2!$H$2:$H$45812,0),0)),"") in Z column
=IFERROR(INDEX(Sheet2!$C$2:$C$45812,MATCH(J280&"|"&Q280,INDEX(Sheet2!$C$2:$C$45812&"|"&Sheet2!$H$2:$H$45812,0),0)),"") in AA column
J and Q column is from the System workbook
Formula should apply till the last row of the Data workbook.
4. Once forumula runs in the System workbook column Z and AA
I would like to match the values in AC column =Z2=Q2 till last row and in AD column =AA2=J2
5. Filter for true value in both columns and update status as Yes in V
since my data is huge , I would like to do VBA.
Thank you in advance