How do I insert current date every time I open the file (same)  | |  In excel I want everytime when I open one particular file serial number and date should automatically be updated.
Is there any procedure in Excel?
If so please let me know.
Thanks & Regards,
| |
| |
| | | | Stamps.com US Postal Printing Postage Is Easy w/ Just A Printer, PC& Internet! Free Trial. www.Stamps.com
| Program Excel in Minutes It is Easy to Automate Excel w/ this Macro Add-in. Free 30 Day Trial. www.xllerate.com
| Make a Latino Date Latino personals in the USA and Canada. Browse pictures and video. www.latinopeoplemeet.com
|
|
| | | | | | 1.  chiyosan (7674) | 3 months ago |  hi there. if you want your file to display the current date just put this formula on one of the cells:
=now()
it should do the trick for you.:)
let me know if it helps. regards!
| |
| |
|
|
 kunalgaurr (314) | 3 months ago | Thanx buddy!
But when I open the same file next day. Will it automatically update?
ALso I would like to know if I put Number e.g. PO No. - 001 and want to update next time when I make another PO. will it come automatically.
Thanx 'n' cheers,
| |
|
| | Stamps.com US Postal Printing Postage Is Easy w/ Just A Printer, PC & Internet! Free Trial. www.Stamps.com | add comment |
|
| | | 2. agihcam (811) | 2 months ago |  Using the formula=now() in a certain cell will update it daily but the PO-001 will remain as is.If you really want to have it automatically you can use Visual Basic for Application in excel to do such thing.If you are not yet aware of this program in excel, while your excel is open, hit Alt + F11 and click on help to read how it is working.
| |
| |
|
| | Program Excel in Minutes It is Easy to Automate Excel w/ this Macro Add-in. Free 30 Day Trial. www.xllerate.com | add comment |
|
| | | | Free Date Search Browse Photos& Meet Single People Free Search and Profiles. www.True.com
| Fitness Singles Meet Local Fitness Minded People. 80+ Activities. Join Free Today. www.Fitness-Singles.com
| Black Singles Photos Find Black Singles Online. Join Our Free Chatrooms, IM& Photo Gallery. www.BlackSingles.com
|
| | | |
| My First Excel Program
Open new excel file.Right click on sheet1 then view code.On the left side,you can see... | |
Free Date Search
Browse Photos & Meet Single People Free Search and Profiles.
www.True.com | |
Fitness Singles
Meet Local Fitness Minded People. 80+ Activities. Join Free Today.
www.Fitness-Singles.com | |
Black Singles Photos
Find Black Singles Online. Join Our Free Chatrooms, IM & Photo Gallery.
www.BlackSingles.com | |
|
|
|
|
|