Dear Experts,
I have a sheet, which is used for recording the Correspondences. This Sheet contains 5 columns i.e. Date, Reference Number, Sent to, Subject of Correspondence & Remarks.
What I am looking for is to facilitate this work. Is it possible that starting from B2 till B65536, whenever I click on the cell, current date should appear and in C2 till C65536, if I click, should show me next number e.g. if first number is 3127 then by clicking the next cell, it should show me 3128 and so on.
Other cells will certainly be done manually.
I am using Windows 98 & Office 2000.
Thanks for your efforts.
Regards,
Shan
I have a sheet, which is used for recording the Correspondences. This Sheet contains 5 columns i.e. Date, Reference Number, Sent to, Subject of Correspondence & Remarks.
What I am looking for is to facilitate this work. Is it possible that starting from B2 till B65536, whenever I click on the cell, current date should appear and in C2 till C65536, if I click, should show me next number e.g. if first number is 3127 then by clicking the next cell, it should show me 3128 and so on.
Other cells will certainly be done manually.
I am using Windows 98 & Office 2000.
Thanks for your efforts.
Regards,
Shan