Hello,
I wanted to create a template in Excel that will help me calculate some financial values (this template will be used monthly). The data needed to calculate these values come from accounting systems and always have the same structure and tab name.
So I figured out that I would create main tab, where these values would be calculated, on the basis of other tabs that I would move (as a whole tab) to the template file every month from the files delivered by accountant.
However, once I have these tabs moved to my template, the cell values do not update - they show "#VALUE!". Only after I click on a given cell and click ENTER, the value is updated.
Could you please advise me how to update them automatically with macro for instance?
Thank you!
I wanted to create a template in Excel that will help me calculate some financial values (this template will be used monthly). The data needed to calculate these values come from accounting systems and always have the same structure and tab name.
So I figured out that I would create main tab, where these values would be calculated, on the basis of other tabs that I would move (as a whole tab) to the template file every month from the files delivered by accountant.
However, once I have these tabs moved to my template, the cell values do not update - they show "#VALUE!". Only after I click on a given cell and click ENTER, the value is updated.
Could you please advise me how to update them automatically with macro for instance?
Thank you!