Need a macro or a script to tackle an issue with a protected worksheet.
I have 2 excel worksheets. One is a protected worksheet (with no way to open it) and the other is where I have some input data.
The protected worksheet has 2 tabs - Input and Output. The Input worksheet has a few cells (lets say 2 cells) which takes in user input. This is where I want a script that will enter data using the other spreadsheet where I have all the input data.
The protected worksheet then uses the user input to generate a number in a cell in the Output tab. This cell is protected. I would like to copy the number from the output cell and paste it in the row of the spreadsheet from where the original input data was used.
Example of Input data (comma used as column separator):
Row 1: 10, 30000
Row 2: 15, 40000
Row 3: 15, 30000
Row n: 20, 600000
I can have over a hundred rows of input data.
The output data from the calculated cell in the protected worksheet should be copied right next to the last column of the respective input data row.
For an excel expert this should be fairly simple problem to tackle.