It is very much possible, In the Workshet_Change() event, see if the target cell is QUANTITY NUMBER Cell, if yes, then if the Start And End Serial numbers cells are empty, set the values for those cells.
Regards Ajit -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Basta Sent: Thursday, August 06, 2009 11:41 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: auto fill start/end serial numbers and date when qty entered im using formula now, and i dont like filled cells, cause some people will be confused when they see many data, lots of numbers going down, but if it possible to change fields like i found script for date auto fill, like line by line, without copying anything, just enter qty number and that's it. :) thank you. --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
