Good afternoon,

I have a password-protected spreadsheet called "JOB A"

1.PNG

I also have another sheet called "JOB B" also with a password that must pull data from "JOB A".

2.PNG

However, when I try to pull the data, Excel throws the following error:

3.PNG

I know it's because of the password because when I remove the password from "JOB A" it manages to pull the data. However, I cannot leave this spreadsheet without a password, because it has sensitive data.

How should I proceed? Is there any way to pull data from spreadsheets with a password?
Or do you need to do a VBA to unlock them and after pulling the data lock again? If yes, could you provide me? Please Help me