+ Reply to Thread
Results 1 to 6 of 6

Auto Number with header row and Formatting

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    New Jersey USA
    MS-Off Ver
    Excel, 2003, 2010
    Posts
    5

    Auto Number with header row and Formatting

    Issue Number 1: I have a task list that I am trying to set up an auto number VBA code for. I have a header row in my work sheet and i would like that to be excluded from the count or auto number. I have already figured out how to do auto date and time entry but I am struggling with auto number. Can someone please help? I have pasted the code I currently have below as well as a listing of the column headers for reference.

    Row 1 - Headings
    Column A - ID# (Auto)
    Column B - Date (Auto)
    Column C - Time (Auto)
    Column D - Issue (Manual Entry)
    Column E - Responsible Party (Manual Entry)
    Column F - Actions Taken (Manual Entry)
    Column G - Status (Dropdown List)
    Column H - Cost (Manual Entry)

    Please Login or Register  to view this content.
    Issue Number 2: I currently have the Status column set up with conditional formatting so that the 3 different options appear as different colors (Open=Red, In Progress=Yellow and Closed=Black). This however only changes the color the single cell of column G. I would like to have it color the ENTIRE row and change when the value in column G changes. Is this possible? If so how?

    Thanks in advance
    Attached Files Attached Files
    Last edited by emsjunkie310; 06-09-2011 at 04:36 PM. Reason: Attachment Aded

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Auto Number with header row and Formatting

    First part:

    Please Login or Register  to view this content.
    Second part:

    use: Formula is: =$G2="Open" ... etc as the condition on all the cells. Select cell A2 to whatever before you make the change or you will get unusual results.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-09-2011
    Location
    New Jersey USA
    MS-Off Ver
    Excel, 2003, 2010
    Posts
    5

    Re: Auto Number with header row and Formatting

    Can you elaborate a bit more...I am confused by what you mean. Its not very clear.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Auto Number with header row and Formatting

    Have a look at the updated example file.

    Regards
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-09-2011
    Location
    New Jersey USA
    MS-Off Ver
    Excel, 2003, 2010
    Posts
    5

    Re: Auto Number with header row and Formatting

    Ok thanks...Issue 2 is solved.

    the auto numbering still isnt working. It is giving me

    "Run-time error '13':
    Type mismatch

    I don't know what is wrong.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Auto Number with header row and Formatting

    I suspect that there is a non numeric ID in the previous row. Even a space would cause it.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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