Ask Your Question

auto numeration in every sheet ? [closed]

asked 2019-02-18 19:35:33 +0200

Afronex gravatar image

updated 2019-02-18 19:36:32 +0200

I am working with information every day. I am tired several times a day copying sheet and changing numeration in every sheet. Is there any way to create automatic numeration in every sheet ? example: Sheet1 and starting number in cell A1 is 500. I create new sheet (sheet2) and number in cell A1 now is 501. Again i create new sheet (sheet3) and number in cell A1 now is 502 and go on.

Sorry for my bad english, but i hope u will understand what i want to know :D

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Afronex
close date 2019-02-19 12:04:16.357559

1 Answer

Sort by » oldest newest most voted

answered 2019-02-18 22:55:25 +0200

m.a.riosv gravatar image

You can get the sheet number with =SHEET() function so =ROW()+500*(SHEET()-1) should do what you like.

edit flag offensive delete link more


Thank you, but how to make this formula to appear automatically in every new sheet ?

Afronex gravatar imageAfronex ( 2019-02-18 23:33:20 +0200 )edit

I think the simplest way it's when you have a clean sheet with the formula, copy it to a new one before put date in ti.

m.a.riosv gravatar imagem.a.riosv ( 2019-02-19 22:35:14 +0200 )edit

Question Tools

1 follower


Asked: 2019-02-18 19:35:33 +0200

Seen: 42 times

Last updated: Feb 18 '19