ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto number for a parts list. (https://www.excelbanter.com/excel-discussion-misc-queries/231790-auto-number-parts-list.html)

Heroplumber

Auto number for a parts list.
 
I want to auto number a parts list . How do you do that with part text and
part number. Example ( MJCF1/2-001,MJCF1/2-002,MJCF1/2-003)

How could I auto number this way?

ward376

Auto number for a parts list.
 
If I understand your question correctly, you can increment these
numbers by dragging the fill handle - enter MJCF1/2-001 in a cell,
then put the mouse pointer over the little box in the lower right
corner of the cell until the cursor changes, left-click and drag
down.

Cliff Edwards


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com