How to rename multiple sheets? Macro?

asked 2018-02-19 11:29:26 +0100

m3110w gravatar image

How can I sum across multiple sheets in Calc? I've got multiple sheets (about 60) in my workbook and I've given all of them unique names. Creating the formula by typing in each name would take too long.

I look for a Calc Extension to do this but didn't see any. Any ideas?

Thanks.

edit retag flag offensive close merge delete

Comments

So do you want to rename the sheets, or do you want to sum across them, as in =SUM(Sheet1.A1:Sheet3.B2)?

Mike Kaganski gravatar imageMike Kaganski ( 2018-02-19 11:34:32 +0100 )edit