[Solved] [Basic] Replace Sheet with a new one

Awara_973 · Post by **Awara_973** » 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 !

edit this topic's initial post · Post by **Villeroy** » Mon Jan 29, 2024 7:09 pm

Use a document template.

Awara_973 · Post by **Awara_973** » Wed Jan 31, 2024 11:48 am

Thank you for your answer. Which option of the templates corresponds to my needs please ?

Mr.Dandy · Post by **Mr.Dandy** » Wed Jan 31, 2024 12:38 pm

No options, just save as OTS

Awara_973 · Post by **Awara_973** » Fri Feb 02, 2024 5:20 pm

Thank you !