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.
Bookmarks