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.
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.
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?
Trying to solve a more complicated format. Thank you
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.
All times are GMT -7. The time now is 03:01 PM. |