+ Reply to Thread
Results 1 to 6 of 6

insert numbers in cells after name to correspond with days worked.

  1. #1
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    insert numbers in cells after name to correspond with days worked.

    Hello all, my question hopefully is fairly simple, i am trying to insert numbers into an excel spread sheet. What I have is a spreadsheet with names, I would like to add a number into the same cell.....i know that in itself is a no brainer.....what i would like to do is to be able for the number to increase by one each day as long as the name stays the same. This is being done manually now, but was hoping to be able to "simplify" my project. thanks for any and all responses. Michael
    Last edited by problownchild; 10-24-2011 at 06:13 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: insert numbers in cells after name to correspond with days worked.

    I suggest you attach a copy of your workbook for us to work with. Be sure to replace any confidential info with dummy data before doing so.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: insert numbers in cells after name to correspond with days worked.

    Trish in Oz, thanks for a reply....i thought I had attached one....will try again.

  4. #4
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: insert numbers in cells after name to correspond with days worked.

    Here it is I think.
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: insert numbers in cells after name to correspond with days worked.

    It appears you want to type the name into the cell - say, C5 - then have the same cell automatically update with the next number being inserted. If this is correct I expect programming is required which is way outside my experience.

    A simple manual method without opening and editing the cell every day is to do this:

    - Click on cell B5.
    - Look for the "fill handle" - a little black box - in the bottom right corner of the cell border.
    - Drag this fill handle into cell C5 and you will see that the number 2 is automatically incremented to 3.

  6. #6
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: insert numbers in cells after name to correspond with days worked.

    Thanks Trish for the reply......Australia is on my bucket list.....have a great day.
    Michael

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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