[Solved] [Basic] Replace Sheet with a new one
Posted: Mon Jan 29, 2024 4:38 pm
Hello everybody,
I'm working on a calc file which is using two sheets including a sheet with a lots of name.
The first sheet deals with the datas of the second one.
My colleagues will have to work with that file, so every first sheet (of my colleagues) will be different.
My problem is that I need to put regularly up to date the second one with new datas.
So, my idea is to send as often as needed the new 2nd sheet to my colleagues. If such a macro exists, they just would have to select the button "Update this file" and a window would launch. Then, the users just have to select the path of the new file and then the program would replace the old second sheet with the new one.
Is this possible ?
Attached is a file which could be useful to imagine what I need.
Thanks a lot !
I'm working on a calc file which is using two sheets including a sheet with a lots of name.
The first sheet deals with the datas of the second one.
My colleagues will have to work with that file, so every first sheet (of my colleagues) will be different.
My problem is that I need to put regularly up to date the second one with new datas.
So, my idea is to send as often as needed the new 2nd sheet to my colleagues. If such a macro exists, they just would have to select the button "Update this file" and a window would launch. Then, the users just have to select the path of the new file and then the program would replace the old second sheet with the new one.
Is this possible ?
Attached is a file which could be useful to imagine what I need.
Thanks a lot !
