Forum Discussion
Solved
'Open-ended' sequential numbering of Rows in Excel...
I have been looking at the SEQUENCE function but, if I understand it correctly, you need to enter an end point for how many sequential numbers you want Excel to autofill (e.g. 1 to 1000)? Is there ...
I hope it is OK to ask a follow-up question on this Thread...
If I want to continue the automatic, sequential numbering of Rows on the next Worksheet in the SAME Workbook, is that possible?
For instance, if sequential numbering of Rows on Sheet 1 is let's say, 1 to 100, can I start sequential numbering of Rows on Sheet 2 at 101? TIA
If I want to continue the automatic, sequential numbering of Rows on the next Worksheet in the SAME Workbook, is that possible?
For instance, if sequential numbering of Rows on Sheet 1 is let's say, 1 to 100, can I start sequential numbering of Rows on Sheet 2 at 101? TIA
Does this do what you want?
=SEQUENCE(COUNTA(B:B), , COUNTA('Sheet 1'!B:B)+1)
where Sheet 1 is the name of the first sheet.
- That worked, thanks. Hopefully I can edit it to work across multiple Worksheets in my Workbook.
- I spoke too soon...! It worked between Sheet 1 and Sheet 2 - numbering continued from the last number on Sheet 1 and started with the next number on Sheet 2 - but even though I changed the Sheet Name in the function between Sheets, the numbers auto-filled in the following Sheets were not as expected!
