+ Reply to Thread
Results 1 to 2 of 2

Date on Particular Column Excel Sheets

  1. #1
    Registered User
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    10

    Date on Particular Column Excel Sheets

    Hi Friends,

    Please advice solution for below scenario.

    Scenario:

    1. Open Excel (Particular file named "X")
    2. On column A type today date. Enter Invoice number eg. "A123") on column B
    3. Press Enter
    4. Key in today date on Column A. Enter another Invoice number eg. "B123 on column B
    5. Repeat above for a number of rows.

    Problem Statement:

    How can I automate the date entry on Column A.

    Requirements:

    1. When the sheet is opened, today date should be automatically entered on Column A. (Remember the date will change every day)
    2. After Key in Invoice Number in Column B, after clicking enter, the next cell to be active is next row 1st cell in Column A.
    3. Once the cell is active, today date should be entered automatically.

    Kindly looking forward for your solutions.

    Thank you
    Muthu.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Date on Particular Column Excel Sheets

    This sounds like a homework assignment?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 13
    Last Post: 10-21-2014, 03:29 AM
  2. Excel 2003 sorting lot of data, multiply sheets by date
    By jevtabg in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-09-2014, 01:45 PM
  3. how to add date to weekly time sheets in one excel file
    By juerges9 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-11-2013, 02:12 PM
  4. Replies: 0
    Last Post: 04-19-2012, 11:53 AM
  5. Date independent of System date in column of Excel
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2011, 06:30 AM
  6. Txt data to excel sheets beyond 256 column limitation
    By prasad96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2007, 09:51 AM
  7. Replies: 1
    Last Post: 07-18-2006, 02:40 PM

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