Hello-
I have a workbook with values in column A and the corresponding reference workbook, sheet in column B and C respectively (Col B has workbook name and C has sheet within the workbook).
I need a code such that if a value is missing in Col A, then it should bring up an inputbox, open up the reference workbook, such that the user can select the value from the reference sheet.
This all should be done within the if loop when Col A values are checked.
Help!
I have a workbook with values in column A and the corresponding reference workbook, sheet in column B and C respectively (Col B has workbook name and C has sheet within the workbook).
I need a code such that if a value is missing in Col A, then it should bring up an inputbox, open up the reference workbook, such that the user can select the value from the reference sheet.
This all should be done within the if loop when Col A values are checked.
Help!
Last edited: