• 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

Logit

Active Member
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

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

Top