Hi LO-sages,
I have a spreadsheet which contains a budget scenario. I now want to develop a second scenario with some changed parameters in a second sheet but want both sheets to be connected so that if I change for example the name of some items, they get changed in both sheets.
My way of doing that is very simple, I use = in all cells of the second spreadsheet to simply duplicate the first sheet and copy the format manually. The problem is that this method returns a hyphen for every empty cell. I am sure it is possible to change this but could not find where. Help would be great!
Thanks in advance.