Comunicação por Macro VBA

Job ID: 31718025

Budget: $10 – $30 USD

I need to carry out communication between 2 sheets via macro programming. The first spreadsheet contains 5 different variables that will have their random values ​​generated by Monte Carlo Simulations (respecting the allowed ranges for each variable) and the second spreadsheet will receive these simulated values ​​separating them into 5 columns (respective to each variable).
The objective is, through communication between macros, to transfer the random values ​​of each variable (generated by Monte Carlo Simulation) from one spreadsheet to another.
Related categories: Excel Excel VBA Excel Macros Power BI