Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Copy/Paste From One Sheet to Another

I have a Budget spreadsheet that I have been using for years in Excel. There is a separate sheet for each month. With Excel I would create the first month and then copy the entire sheet and paste it to the other 11 sheets. I then could tweak each month as needed.

I created this years Budget spreadsheet the same way with Calc. Unfortunately I have discovered that each months formulas are pointing at January's fields instead of being relative to the individual months. Kind of messed me up since the balances are obviously wrong.

Is there a way to copy/paste the sheet without it including the reference to the original sheet in the new sheet?

Also, when I tried copying the individual fields I have found that if I press enter after the copy, it wipes out copy buffer and I have to select and copy the value again. This doesn't make sense.