• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add password to file

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
 

Attachments

  • Demo.xlsx
    103.9 KB · Views: 3
Example of the formula : =LEFT(E2,1)&B2&C2

Your description is somewhat confusing. Let me know if this is what you meant.
Also, it is much easier to have all the data on the same sheet.
 

Attachments

  • Demo.xlsx
    103.9 KB · Views: 3
Example of the formula : =LEFT(E2,1)&B2&C2

Your description is somewhat confusing. Let me know if this is what you meant.
Also, it is much easier to have all the data on the same sheet.
No What I am trying to say is I have main data in sheet 1 and sheet 2 is an example what I need

To give brief on this :
  • SE no (which is an unique ID) for a team.
  • A team has group of user and their workbook respectively on a given folder. For ex : C:\Desktop\9281\Aman.xlsx
  • What I need is all the Workbook for a given SE no should be password protected with unique password as given on the sheet 2 in col c of sheet 2
Please look into the sample and help me if this can be done.
 

Attachments

  • Demo.xlsx
    148.9 KB · Views: 4
Back
Top