Hi,
I was wondering if anyone could help me out. I am trying to do a lot of things at the same time and I have honestly no idea where to start.
So I have a workbook with several sheets in it. This workbook needs to be made in 2 different languages. I have a droplist where I can select the language and it will translate all the necessary data.
What I want to now is add a macro that will copy certain sheets to a new workbook and will change the name of certain sheets based on the value in my language droplist.
No all sheets need to be copied and only the print area needs to be copied.
The name for the new workbook is also different depending on the language (preset value in 2 fields)
Appreciate all the help I can get
I was wondering if anyone could help me out. I am trying to do a lot of things at the same time and I have honestly no idea where to start.
So I have a workbook with several sheets in it. This workbook needs to be made in 2 different languages. I have a droplist where I can select the language and it will translate all the necessary data.
What I want to now is add a macro that will copy certain sheets to a new workbook and will change the name of certain sheets based on the value in my language droplist.
No all sheets need to be copied and only the print area needs to be copied.
The name for the new workbook is also different depending on the language (preset value in 2 fields)
Appreciate all the help I can get