Hi
very new to this site and new to Excel, I have a spread sheet with 8 different tabs, all with different information, I want to add a new row to ALL tabs, which I have no problem doing, but how do I get formulas to be automatically inserted / copied from the above line, I have various formulas across all tabs working out different values.
I have looked into VB as I have read this will do it, but I would need very basic step by step instruction
thanks
Welcome here. I assume you mean you’re new to LibreOffice Calc (not Excel).
A simple way without VB: Click on the header of the inserted line (the line is selected) then Ctrl+D
This will duplicate the line above: formulas, styles, formatting, validity, etc. The values are also duplicated but need only modify what changes.
Regards
Hi
For what I am trying to achieve I think VB script is the only way, is there any way I could send workbook to you?
Regards