View Full Version : Sequential numbering in excel 2007?
Naaldekokker
Jun 25, 2011, 05:09 AM
Sequential Numbering in Excel Sheets. Sheet 1 - Copy to Sheet 2 But No in Cell "A1" must Change to next No i.e 0001 to 0002.
BK201
Aug 1, 2011, 04:40 PM
Im not sure if this is what you want but
go to sheet 2, click on cell A1, type this
=sheet1!A1+1
drag and drop it to the other cells below.
Or are u trying to solve a more complicated format?
Naaldekokker
Aug 2, 2011, 03:06 AM
Trying to solve a more complicated format. Thank you
ScottGem
Aug 2, 2011, 03:19 AM
First when posting a follow-up question or info, please use the Answer options at the bottom of the page rather than the Comments.
Sequential numbering is easy in Excel, you simply enter a formula that increments another value by 1. To help further you need to be more detailed about your needs.