Essentially, I have a table that makes an amortization calculation based on information entered on another tab. I would like to create a macro that would copy/paste the previous period's table and then update the information in that table with the current period's data. I would like to trigger this macro when I enter new information on the other tab. Can anyone help me make this happen? Let me know if anyone needs additional information. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to Copy/Paste and Update a table based on Value entered in a Cell
Similar threads
- Question
