Hello,
I need to call a sub with each time my Data Tables calculate.
I use a macro to copy and paste a cell's value from one sheet to another so that I can create a few data tables. The way the data tables (under What-if Analysis) are working together is causing some problems as the cell that is being copied and pasted is not updating as the various data tables run. Is there a way to call the basic copy and paste macro with each iteration of the Data Table run?
Thank you.
Bookmarks