Quote:
Originally Posted by aslamyahya
The problem is this,
I have this calculation script that i have to use for around 100 times
...
I have values AAAAA, BBBBB, CCCCC, TRANSMTR1, TRANSMTR2, TRANSMTR3 and FINALXMTR in another sheet.
Can anyone help me with some macro that would enable me to do this
|
Without knowing where:
• your script is kept (eg a text file or a worksheet); or
• the values you want replaced can be found on the other sheet,
responding to your request requires some guesswork.
The attached Excel workbook assumes your script is kept on Sheet1 and the values are kept on Sheet2. Once you've input the data on Sheet 2, simply enter the number of a required script in cell A1 of Sheet1 and the script below will be updated. You can then copy/paste or export the script to wherever else you require it.
PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.