The "import" button on the attached sheet entitled "master query log" is designed to automatically add the details of the chosen file sheet to the bottom row of the master query log spreadsheet. However in the future the files that need to be imported will be password protected (current sheet).
1.Could someone change the coding of the macro assigned to the "import" button so it will import the same information as it is currently set up to but for the attached sheet "random query". I have attached an example of the previous import file (query) for you to test and see how it should work for the "random query" template instead.
Note: import files will always be in the layout and format of that found in the attached "random query" sheet. They will always be current sheet protected with the password trinity.
2. Automatically unlock the incoming sheet so it can be copied into the master query log. The password is trinity