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 !
[Solved] [Basic] Replace Sheet with a new one
[Solved] [Basic] Replace Sheet with a new one
- Attachments
-
- Replace_sheet_with_another_doc.ods
- (29.43 KiB) Downloaded 106 times
Last edited by Hagar Delest on Sat Feb 03, 2024 6:26 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Libre Office 7.3.7.2 With Ubuntu 22.04.3 LTS
Re: [Basic] Replace Sheet with a new one
Use a document template.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: [Basic] Replace Sheet with a new one
Thank you for your answer. Which option of the templates corresponds to my needs please ?
Libre Office 7.3.7.2 With Ubuntu 22.04.3 LTS
Re: [Basic] Replace Sheet with a new one
No options, just save as OTS
OpenOffice 4.1.12 - Windows 10
[Solved] [Basic] Replace Sheet with a new one
Thank you !
Libre Office 7.3.7.2 With Ubuntu 22.04.3 LTS