+ Reply to Thread
Results 1 to 4 of 4

autonumbering column with header

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    Munich
    MS-Off Ver
    365
    Posts
    5

    autonumbering column with header

    Hi everybody!
    I'm trying to autonumber column "A" from a table that has a header in row 1.
    The autonumber goes automatically till the last row with data in "B".
    My problem is that i don't know how to tell the code that there is a header in row 1 and autonumbering should start in row 2. Can anyone give a hand pls? thank you so much

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: autonumbering column with header

    Is it?
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: autonumbering column with header

    try this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    10-23-2019
    Location
    Munich
    MS-Off Ver
    365
    Posts
    5

    Re: autonumbering column with header

    thanks! that was it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Autonumbering column
    By Simply_Me in forum Excel General
    Replies: 8
    Last Post: 04-06-2017, 01:42 AM
  2. Helped needed to index match row header, column header, and sheet
    By vw103604 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2016, 12:37 PM
  3. Autonumbering a column
    By NaomiDawn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2015, 10:19 AM
  4. Replies: 1
    Last Post: 10-05-2013, 03:35 PM
  5. Autonumbering Base on other Column Data
    By ajdluistro in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2013, 05:24 AM
  6. Autonumbering a column
    By nemmeh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2009, 10:33 AM
  7. code for autonumbering a column
    By tushar joshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2006, 09:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1