Dear, I have a monthly routin task and I'd like to know how can I automate it (if possible without using VBA). So every month closing I need to copy the newest exchange rate I get from the headquarter and paste in value to the closing month. So in my excel, 4 is newest exchange rate for January and is hard coded value. 1-3 are closed periods so are hard coded value. 5-12 are formulas equal to value for 4. Can I automate this process somehow? Thanks
Hi Yuan Zhang,
Can you attach a file with anonymised data that shows the basic data to be processed and then the result you want to achieve?
BR,
Lionel
I have another scenario with similar need but this one is easier to follow. So every month, I need to copy the formulas from last month (in the example month P03 on column e.g. X4=+C4 ) into the closing month (in the example month P04 on column Y). I need to then copy paste the value on column X into hard coded value. Then after I refreshed the pivot table, the value for the closing month will be updated in column Y but past periods will stay hard coded with the historical values. 
I hope this is clear? Thanks!
