Hello everyone!
I have a really complex (in my opinion) vba request if someone can please help me.
I have an Excel file with 4 sheets.
Input raw,
Input,
Discount Factors,
Upload.
From Input raw I need to take the data and put it into Input by year. To be more clear, for example I have data from 2020, 2019, 2018. first it needs to take the 2020 data and put it into input, after that delete it, then the 2019 and delete it and last 2018 and delete it.
Based on the rows that are copied from Input raw into Input there are some formulas in Discount Factors sheet. that is why i need the data copied year by year. When the data from one year only is in Input, in Discount Factors some cells needs to be copied into Upload sheet.
To summaries everything:
one year data only copied from Input raw into Input.
from Discount Factors some cells needs to be copied into Upload sheet
delete what is in Input sheet
copy next year data
and so on... until there are no more years...
Is it someone able to help me please? Is it possible to do this in VBA? I can share the excel :D
Thank you so much!!
I have a really complex (in my opinion) vba request if someone can please help me.
I have an Excel file with 4 sheets.
Input raw,
Input,
Discount Factors,
Upload.
From Input raw I need to take the data and put it into Input by year. To be more clear, for example I have data from 2020, 2019, 2018. first it needs to take the 2020 data and put it into input, after that delete it, then the 2019 and delete it and last 2018 and delete it.
Based on the rows that are copied from Input raw into Input there are some formulas in Discount Factors sheet. that is why i need the data copied year by year. When the data from one year only is in Input, in Discount Factors some cells needs to be copied into Upload sheet.
To summaries everything:
one year data only copied from Input raw into Input.
from Discount Factors some cells needs to be copied into Upload sheet
delete what is in Input sheet
copy next year data
and so on... until there are no more years...
Is it someone able to help me please? Is it possible to do this in VBA? I can share the excel :D
Thank you so much!!