Aman Semwal
Member
Hi,
Please look into the sample file.
I have main data in sheet 1.
What I need is that in sheet 2 I have data in column A & B. Column A is the SE no and Column B is the workbook file name which is in path C:\desktop\new folder. For Ex : Aman is the file name.
What I want is that all the file should be password protected with a criteria i.e data which is on sheet 1.
Explaining with an example :
Sheet 2 data should look up the SE no within sheet 1 table and create a password as
FIRST LETTER & UNIQUE ID & CODE to the workbook in column B of sheet 2
Please look into the sample file.
I have main data in sheet 1.
What I need is that in sheet 2 I have data in column A & B. Column A is the SE no and Column B is the workbook file name which is in path C:\desktop\new folder. For Ex : Aman is the file name.
What I want is that all the file should be password protected with a criteria i.e data which is on sheet 1.
Explaining with an example :
Sheet 2 data should look up the SE no within sheet 1 table and create a password as
FIRST LETTER & UNIQUE ID & CODE to the workbook in column B of sheet 2